Posted: Tue Sep 26, 2006 3:44 pm
Do an ereplace of that character with char(010):char(013).
The text marks indicate that your column width may not be adequate, rather than separate lines (unless you are selecting from a multi-valued field, in which case you can use DataStage's "normalize on" capability).
You can override the default column width with a FMT keyword in your UniVerse query.
Before I go off exploring possibilities, what precisely are you trying to do?