DSXchange

My input file is in the form abc|xyz|lmn|...
I need to substitute the pipe character (|) with the new-line character.

I need full syntax for the function "substitute" in my map, so that my output file would be
abc
xyz
lmn
and so on ...


Thanks in Advance
Sneha

Hi Sneha,

Welcome Aboard :D !!!
Should be char(13) with the convert function.

New line in Windows is CR LF or 0D0A. When run on Unix I believe its LF or 0A.

So you could use substitute(text, "|", "<NL>") and it should replace the character according to the environment your compiled in. If you want to make sure its alway Line feed do one of the following....

substitute(text, "|", "<LF>")
substitute(text, "|", "<<0A>>")