Line breaks lost while export from or import to CSV file.

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
egdd
New User
Posts: 7
Joined: Thu Oct 15, 2015 10:46 pm
Are you a spam bot?: No

Line breaks lost while export from or import to CSV file.

Post by egdd »

I noticed in the desktop version (Windows 7) 1.2.2 that I cannot import or export line breaks in the note field.
My delimiter character is a {TAB}. Neither a line break using the {ENTER}-key or escaping them using "\n" did work.

If I create a note like this:

Code: Select all

a
b
in the CSV-file it gets outputted as

Code: Select all

a b
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Line breaks lost while export from or import to CSV file

Post by Nikolay »

It's csv parser restriction. One transaction should be placed one line in csv file.
But in future it may be an option added to avoid EOL replacements.
egdd
New User
Posts: 7
Joined: Thu Oct 15, 2015 10:46 pm
Are you a spam bot?: No

Re: Line breaks lost while export from or import to CSV file

Post by egdd »

I see, how unfortunate.

What about a workaround? Can you import and export using escape characters, e.g. a line break is symbolized by "\n"?
In the example that would result in an text to be imported like this:

Code: Select all

a\nb
becomes converted to to the following in the note field:

Code: Select all

a
b
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Line breaks lost while export from or import to CSV file

Post by Nikolay »

I'll try to use '\n' instead ' ' (break). If it will work - it will released in next vertion.
egdd
New User
Posts: 7
Joined: Thu Oct 15, 2015 10:46 pm
Are you a spam bot?: No

Re: Line breaks lost while export from or import to CSV file

Post by egdd »

Thank you very much, if that works, that should do it!
Post Reply