DEV Community

Peter Perkins
Peter Perkins

Posted on

CSV record count not matching your source? πŸ™ˆ

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.

Image description

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

πŸ‘‹ Kindness is contagious

Please leave a ❀️ or a friendly comment on this post if you found it helpful!

Okay