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"
TXT file generation
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
TXT file generation
Thanks
Deepak Patil
Convince Them Confuse Them .. What's the difference?
Deepak Patil
Convince Them Confuse Them .. What's the difference?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers