How can I use row delimiter other than \n?

CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter.

I'm using Excel 2010, and in need to convert that CSV file to Excel format.

If it can't be done with Excel then is there any other software which allows you to do so?

So far I've tried Excel, Open Office, and CSVed.

  • 2
    would you mind, showing a line of your csv and to what you would want to change that. Because, right now, I would just suggest you open this with an text-editor and replace \n\n\n\n with ; or whatever. – Jook Nov 8 '12 at 8:26

First I need to be honest - I have close links with the author of this software, having had quite some involvement in its development (ideas, testing etc.). I have been busted for over promotion already, but in my defense I used to constantly fight with Excel and now I use Ron's Editor daily.

As I said I use something called Ron's Editor a lot and I know it lets you change the line break format for cells and rows. However it lets you change them to other line break formats and from your question it is not clear if that is what you need.

Once you have the file as you want it in Ron's Editor it will correctly export the CSV file to Excel, without mucking up the formatting etc.

I hope that helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.