Skip to content

How to address line breaks in CSV Files

April 18, 2009
Snapshot of a text file saved under the comma-...

Image via Wikipedia

Found this pearl. Useful when moving data using the Data Wizard or the straight import facility of CRM.

“What i’ve always done (this is a hack but it works) is to save my CSV file in html format (via Excel). Then you can open the HTML file and do a find-and-replace for all <br>’s (line breaks) and <p>’s (paragraphs) with an escape character like ” / “.  Then save the file, re-open in Excel, and save-as CSV. This gives you a new CSV file without the line breaks”

Source: Ryan Casey’s answer to this thread: How can I import data (CSV) with line breaks?

Happy de-breaking!
Alberto “Break Like The Wind” Gemin

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: