Page 1 of 1
Line breaks lost while export from or import to CSV file.
Posted: Mon Oct 19, 2015 11:19 am
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:
in the CSV-file it gets outputted as
Re: Line breaks lost while export from or import to CSV file
Posted: Mon Oct 19, 2015 2:39 pm
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.
Re: Line breaks lost while export from or import to CSV file
Posted: Mon Oct 19, 2015 5:49 pm
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:
becomes converted to to the following in the note field:
Re: Line breaks lost while export from or import to CSV file
Posted: Tue Oct 20, 2015 10:16 am
by Nikolay
I'll try to use '\n' instead ' ' (break). If it will work - it will released in next vertion.
Re: Line breaks lost while export from or import to CSV file
Posted: Wed Oct 21, 2015 8:06 pm
by egdd
Thank you very much, if that works, that should do it!