DSXchange

Hi ,

I am trying to convert .txt to .csv , it is comma delimited ...

Data looks like this;

"120","120","","7935","221539559","0", "PPM, NJ INC/GAL" ,"PPM, NJ INC/GALE CENTER",""


When I am converting it and viewing it in to datatsage its saying too many columns in record...


I am confused as there are commas inside double quotes , then too I am getting this error..

Please suggest ..

The comma inside the quoted string should not be a problem. Are you certain you told it you had double-quotes for the quote delimiter?

I think the error is due to other data element which has etra double quotes ...

Thanks..

Something you didn't post an example of? Yes, those would be a problem.