CSV End of line
27,945
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.
Author by
sanu
Updated on July 09, 2022Comments
-
sanu almost 2 years
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 belowMedicine;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