last ;(semicolon) missing after FTP

kusuma · Post by **kusuma** » Thu Nov 09, 2006 3:23 pm

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

kusuma · Post by **kusuma** » Fri Nov 10, 2006 12:56 pm

It works if I treat the whole row as a single column and transfer the file. But if some one has an alternate/better solution, please share

Thanks,
Kusuma

kris_daredevil · Post by **kris_daredevil** » Fri Nov 10, 2006 1:10 pm

check the properties tab in the FTP stage look for column delimiter,escape charater

kusuma · Post by **kusuma** » Fri Nov 10, 2006 1:33 pm

kris_daredevil wrote:check the properties tab in the FTP stage look for column delimiter,escape charater

Hi KRIS,

Right now, my Column Delimiter is ;(semicolon) and the Escape Character is \(default). But it is not working with this. Am I doing somthing wrong?

Thanks,
Kusuma

chulett · Post by **chulett** » Fri Nov 10, 2006 2:08 pm

kusuma wrote:It works if I treat the whole row as a single column and transfer the file.

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'.