CSV End of line

Question

Hi i am trying to put end of line code in CSV format to import it to excel I tried putting
\n, "\n", \r, "\r", \r\n, "\r\n" but nothing worked for me I am trying to import it in excel 2013 my csv format is like below

Medicine;1213;22;19\nMedicine (miscellaneous);1013;32;55\nEngineering;708;14;21

please help. Field delimiter working fine but how to manage line break I want out put like this

Medicine                   | 1213 | 22 | 19   
Medicine (miscellaneous)   | 1013 | 32 | 55   
Engineering                | 708  | 14 |21

Thank you for your any help and suggestions

Does your original input file actually have any kind of line separator? Or, is it just all on a single line? Also, which text editor are you using to modify your CSV file? — Tim Biegeleisen, Mar 08 '17 at 08:31
yes it just all on a single line that why it is not working any idea on it ? — sanu, Mar 08 '17 at 08:32
Are you certain there are no line separators there? Just because it renders on a single line does not mean there are no separators. If nothing really is there, then you might have to add them to get the Excel import to work. — Tim Biegeleisen, Mar 08 '17 at 08:35

score 6 · Accepted Answer · answered Mar 08 '17 at 08:43

6

In Notepad++ you can just do the following find and replace:

Find:

\\n

Replace:

\n

Be certain to do this in regex mode, not regular mode.

answered Mar 08 '17 at 08:43

Tim Biegeleisen

502,043
27
286
360

score 1 · Answer 2 · edited Oct 07 '21 at 13:35

1

CSV uses RFC 4180. So the comment https://stackoverflow.com/a/42666642/9179591 is incorrect. Most use cases are going that the EOL of csv is CR/LF.

In Unix(Ubuntu in my case), you can look it, when you open your file in cat -A /<someYourFilePath>

edited Oct 07 '21 at 13:35

Community

1
1

answered Nov 15 '19 at 15:02

Alex Khonko

40
6

score 0 · Answer 3 · answered Mar 08 '17 at 08:40

0

if the above is your text file. I have found that just pressing enter works in the text file.

example:

Medicine;1213;22;19
Medicine (miscellaneous);1013;32;55
Engineering;708;14;21

This is what worked for me.

answered Mar 08 '17 at 08:40

Janwilx72

502
4
18

June7 · Answer 4 · 2017-03-08T10:19:40.630

0

The \n is just text to Excel. I used Word to Replace \n with Special Character Paragraph Code then saved as a txt file and that imported into Excel.

edited Mar 08 '17 at 10:19

answered Mar 08 '17 at 09:00

June7

19,874
8
24
34

CSV End of line

4 Answers4