import new lines

deichenlaub,

Are you using a delimiter in each cell?

I’m not sure what you are asking. The .csv file looks like this:

Username,Email,license-plate,phone<cr><lf>
usere1,[email protected],123<cr><lf>456<cr><lf>,555-1212<cr><lf>

The two license plates should display on separate lines. Instead, they both display on one line.

I found a solution of sorts. If I allow HTML into the field, I can us the paragraph tag line this:

Username,Email,license-plate,phone<cr><lf>
usere1,[email protected],123<p></p>456,555-1212<cr><lf>

I would rather not allow html, but I can live with this if no better solution is available.

deichenlaub,

Try to use a delimiter of each string, something like:

“Username”,”Email”,”license-plate”,”phone”<cr><lf>
“usere1″,”[email protected]”,”123<cr><lf>456<cr><lf>”,”555-1212″<cr><lf>

And tell me if it works. If you don’t use a character to mark start-end of each string, there is no parser that is able to understand a breakline in the middle.

I did many tests with delimiters and different ways to specify a new line. I can’t find anything that works except to allow the field to accept html. So be it. It’s time to move on.

Thanks for your suggestion. You can close this.

With which program are you creating the CSV file? Have you tried to do it with LibreOffice Calc, for example.

I am moving data from a Microsoft Access database to WordPress. I am using the built-in visual basic, which is quite a powerful and flexible tool.

deichenlaub,

Ok, with this kind of tools I haven’t had any problem about breaklines.

Thanks for all, if need anymore tell me.