DSXchange

I am trying to generate a flat file through datastage from a table. (table copy to a txt file). Has three columns and multiple rows.

After every row it puts line ender (which is enter) and then the next row starts. (pretty standard).

The requirement is that the last line should not have the enter , for e.g. right now it is -

"a b c
d e f
"

I want it like

"a b c
d e f"

This ws simple.. shud have saw the options before posting.....

I'm not sure what your example is trying to show with the double-quotes. A UNIX file would use a line termination character of LF rather than CR, which I assume is what you mean by 'Enter'. So...

I think what you need is to enable is the "Omit last new-line" option on the Format tab. Let us know if that's not the case.

Edit - took too long to compose this, it seems.