Hi all,
I have a sequentional file that looks like
a1;b1;c1;....m1;n1;;
a2;b2;c2;....m2;n2;;
a3;b3;c3;....m3;n3;;
.
.
the last field is empty
I have a ftp job that ftpee's this file to another server, but the output is like
a1;b1;c1;....m1;n1;
a2;b2;c2;....m2;n2;
a3;b3;c3;....m3;n3;
.
.
The last semicolon is missing. Can somebody help me resolve this problem.
Thanks,
Kusuma
last ;(semicolon) missing after FTP
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Mon Dec 05, 2005 8:07 pm
- Contact:
That's how I generally do it - and seems to me the best solution for preserving the struture of the file. The FTP stage is metadata driven and perfectly happy to massage data or change delimiters or do all kinds of other thing to the file while it is 'in flight'.kusuma wrote:It works if I treat the whole row as a single column and transfer the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers