how to remove box character insequential file

[sagar deshmukh]

what exactly i am doing is...i need to read a CSv file, from a remote server to a sequential file, i tried using all the mappings of NLS...I am using FTP stage , in the line ternmination i am using is LF(unix) and the same line termination am using in sequential stage...,

but the output is cooming like this...

'','90028','10: ADULT BB1','12/08/2008','10:54:02','0000062744001','0.95','1'



'','90028','10: ADULT BB1','12/08/2008','10:54:02','0000062744002','0.95','1'



'','90028','10: ADULT BB1','12/08/2008','10:54:02','0000062746001','0.7','1'



'','90028','10: ADULT BB1','12/08/2008','10:54:02','0000062746002','0.7','1'



'','90028','10: ADULT BB1','12/08/2008','10:55:27','0000062750001','0.95','1'



'','90028','10: ADULT BB1','12/08/2008','10:55:27','0000062750002','0.95','1'


am getting box character as well as spaces beteen two record...this has not solved my problem yet.

please help me

[ray.wurlod]

Have you tried specifying DOS-style line terminators?

[sreekanth kutumbaka]

By using MCP function you can remove BOX character , Following is the convert function .
Function to Convert :Convert(".", "", Oconv(InLink.TheString, "MCP"))
Note : But don't use this function to convert amount (i.e 2500.00).

for the amount data use database level filter

to convert in database level : substr(<column_name>,0,(length(<column_name>)-1 ))