DSXchange

Hi All,

I have a simple datastage job where I am extracting the data from a table and I am creating a flat file(text file). These flat files are used to generate reports. But I am getting linefeeds embedded with some of the values coming from certain columns. How can I replace these linefeeds with a null value.

Thanks,
Prasad

You do not want to convert to NULL, you want to convert to zero-length string.
Initialize stage variable svLF to Char(10) and do not supply a per-row derivation expression.