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
Issue with reading csv file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Mon Feb 27, 2006 10:34 pm
- Location: Chennai
- Contact:
Issue with reading csv file
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
Cognizant technologies,Perungudi
Chennai
Re: Issue with reading csv file
Could u set the field default properties as given below -
Delimeter = comma
Quote = none
and then check..
Delimeter = comma
Quote = none
and then check..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.