Page 1 of 1

Sequential File

Posted: Wed Oct 26, 2011 7:58 pm
by phanikumar
I am trying to read data from sequential file where it contains two columns ID and SYSTEM_NAME.My problem here is the data in system name contains quotes,I need to get rid of these quotes before loading in to the target.Any ideas or suggestions around this would be really helpful.

Regards

Kumar

Re: Sequential File

Posted: Wed Oct 26, 2011 9:36 pm
by deeplind07
While readin the file you can read it as 'quoted' and while writing into the target mention it as no quotes.