DSXchange

HI All

I have csv file containing the data like this

Electrical Equipment,ElecEquip
"Engineering, Machinery & Equipment",Engineerin
Entertainment & Broadcasting,Entertain

The first and third record are fine,The issue with secod records as it has comma enclosed with in inverted commas.I need to load the data with in inverted commas in single column .which is not the case.currently the data is beeing loaded as "Engineering in one column and Machinery in second.

Thanks in Advance

Mohammed Tausif

Could u set the field default properties as given below -

Delimeter = comma
Quote = none

and then check..

Please confirm that this is a mainframe job. It seems unusual to me that you have a CSV file on a mainframe.

I note also that you have marked the thread as resolved. The convention on DSXchange is to make a short post indicating HOW it was resolved, the better to aid future searchers.