DSXchange

Hi all,

I'm reading csv file using Sequential file stage with the following format:

Final Delimiter=end
Field Delimiter=comma
Quote=double

but in the source data i'm having "" with in the field itself where sequential file stage reading it as seperate field

for example my source is like:

Page_Name,Page_details,Session_id
"bluewater 9/16"" climb_610111","bluewater 1'' climb-737298",1234
"bluewater_610111","bluewater",1234


But in the target Page_Name and Page_details values are getting cascaded because of this "" with in the field like:




Anyone please let me know how to handle this "" with in the field.

Thanks & Regards,
Kalpana.

Use sed command in filter tab

srinivas.g wrote:Use sed command in filter tab

Thanks for your reply.Can you please tell me the command in detail.
Thanks & Regards,
Kalpana.

sed 's/"//g'