Line Breaks in CSV - Help please

Hi folks,

I have a problem when exporting contacts (as a csv-file).
My contacts often have a bunch of text in the description/comment field.
If this text has any line breaks, there will be a line break in the csv file, which totally messes up the structure for further imports.

For example:
“first name”, “last name”, “despription”, “street name”

–>

“John”, “Doe”, “loyal customer since 1999 {LINE BREAK}
worked for an international bank {LINE BREAK}
has 2 kids and a dog”, “abc-street”

How can I solve this?

Thanks and best regards
cekrse

Try This.

When saving the data in the description field try to remove all characters which causing this issue and save. Then export.
example:
before save:

“loyal customer since 1999 {LINE BREAK}
worked for an international bank {LINE BREAK}
has 2 kids and a dog”, “abc-street”

after save : logic hook
^loyal customer "loyal customer since 1999 worked for an international bank has 2 kids and a dog^

After export
“first name”, “last name”, “despription”, “street name”

“John”, “Doe”, "^loyal customer “loyal customer since 1999 worked for an international bank has 2 kids and a dog^”,“abc-street”.

How should I remove all characters? Manually? I have a large database unfortunately. :frowning:

And it’s not a particular character. It’s a real line break. Everytime someone has hit the enter button in the description text box, the csv-list jumps a row.