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 MMEX 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
MMEX 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 MMEX 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
MMEX 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 MMEX 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