Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
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
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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