extra comma in csv file

aravindunni31 · Post by **aravindunni31** » Thu Apr 23, 2015 3:43 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Apr 23, 2015 5:05 am

Best is to get the provider of the file to give you a correct file.

weiyi_will · Post by **weiyi_will** » Fri Jun 26, 2015 1:18 am

ray.wurlod wrote:Best is to get the provider of the file to give you a correct file. ...

Agree!

ArndW · Post by **ArndW** » Fri Jun 26, 2015 1:29 am

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.