extra comma in csv file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2012 6:51 am
- Location: Chennai
extra comma in csv file
I have a file which is csv and comma separated. I have extra comma in one of my columns. I dont have quotes in my file. If I read via Sequential File Stage, it is getting considered as another column. Is there any way to handle this
Regards,
Aravind V A
Aravind V A
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 10
- Joined: Sun Aug 11, 2013 10:46 pm
- Location: Dalian
What the others have tried to say, indirectly, is that there is nothing DataStage can do if the extra comma is in a column other than the last one. Unless there is a logic to the extra comma (e.g. it always appears in a string "hello, there") you can't read that file.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>