Skip to Content
0
Former Member
Sep 16, 2009 at 07:06 AM

How to solve extra commas in CSV files in FCC..!!

724 Views

Hi,

I have the CSV file with comma(,) separator which has around 50 fields. Among them there were some description fields which has comma (ex: karan,kumar) which has to come as a single field and comes as 51 fields instead of 50.

Due to this, im facing problem at File content conversion and it is failing with error " ERROR converting document line no. 8534 according to structure 'Header':java.lang.Exception: ERROR in configuration / structure 'Header.': More elements in file csv structure than field names specified!

We have around 10 fields which comes in this way.Any idea how to solve this issue?

Thanks

Deepthi.