When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing:
- fields to split (multiple fields) where the where the LineControl characters occur and,
- the field and record to be continued [strong][em]on the following Excel row[/em][/strong].
I've tried the replace comand Replace(T.T_Task_Desc , X'0D', ' '). It is sucessfull in replacing the x'0D' carriage return with a space.
However the same command when used on the X'0A' line break does not seem to work.
Does anyone know of a way I can replace the X'0A' with a space?
April 5, 2010 4:45 PM