DSXchange

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

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

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

Agree!

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.