extra commas in SEQ file

knowledge · Post by **knowledge** » Fri Aug 27, 2010 8:42 am

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 ..

chulett · Post by **chulett** » Fri Aug 27, 2010 8:47 am

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?

knowledge · Post by **knowledge** » Fri Aug 27, 2010 9:09 am

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

Thanks..

chulett · Post by **chulett** » Fri Aug 27, 2010 9:48 am

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