CSV record count not matching your source? You've probably got rouge carriage returns in the source data. If you're in MS Excel you can do a Search and Replace
on the source data before saving as a CSV.
How To:
Search and Replace (in Excel). In the search box type Ctrl + J
to insert a carriage return. It will look like there is nothing in the search box but its there. Click Find All
to find and see all fields with carriage returns. To remove, simply click Replace All
.
Top comments (0)