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.
Error in reading file with field default quotes,sequential
Moderators: chulett, rschirm, roy
Error in reading file with field default quotes,sequential
Kalpana Marupudi
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am