Home > IT Answers > Microsoft Windows > QMF results display as Excel sheet (line feed characters within data fields)
Girwin50
5 pts.
 QMF results display as Excel sheet (line feed characters within data fields)
Excel 2002, Line Feed, QMF
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?



Software/Hardware used:
QMF DB2
ASKED: April 5, 2010  4:45 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _