sequential stage read issue with double quotes used as data
Posted: Thu May 17, 2012 2:27 am
We are reading txt files using sequential stage with Quote property set as 'double'.
But we are getting few rejections for data records like :
7724,"4957","""VENTILATION"" PNEUMONITIS",132,"Lung disease due to external agents",,"","Diagnosis","","".
Here rejects is occurring when there are double quotes used as data, ie "VENTILATION" PNEUMONITIS. To get the data loaded like "VENTILATION" PNEUMONITIS, the data file needs to include extra double quotes, """VENTILATION"" PNEUMONITIS". The first and last " are used to enclose the data field. the 2nd and 3rd is provided to so that the double quote is read as data not as enclose code. The same case for 4th and 5th double quote.
Please help.
Thanks
Abhik.
But we are getting few rejections for data records like :
7724,"4957","""VENTILATION"" PNEUMONITIS",132,"Lung disease due to external agents",,"","Diagnosis","","".
Here rejects is occurring when there are double quotes used as data, ie "VENTILATION" PNEUMONITIS. To get the data loaded like "VENTILATION" PNEUMONITIS, the data file needs to include extra double quotes, """VENTILATION"" PNEUMONITIS". The first and last " are used to enclose the data field. the 2nd and 3rd is provided to so that the double quote is read as data not as enclose code. The same case for 4th and 5th double quote.
Please help.
Thanks
Abhik.