Entire CSV file is not being delimited

nycmhtn23

Hi,

I pulled in the Input Data Tool, selected SharePoint and entered the URL to pick up a .CSV file to import in. Then entered delimiter as comma symbol. In the Preview box it shows only the first row texted to column. In order to see data for the entire file (its not a big report) I have to replace the delimiter with a pipe symbol in order for all the data to show up in the preview box (untexted to column). The comma symbol is definitely the delimiter, why is it only texting to column the first row and not processing the others?

Following warning message also appears:

Too many fields in record #1

BrandonB

It might have some extra header data up top which is why it is saying "too many fields in record 1". What you can do as an alternative is to read it in without a delimiter and then follow up the Input Data tool with a Text to Columns tool. Most CSVs you won't have to do this, but it sounds like you may have some additional information up top that is throwing it off. Alternatively you can keep the comma delimiter, but adjust the "Start Data Import on Line" to the row where the data actually starts.