I have exported text from Excel in Unicode, like this:

enter image description here

then I edit with Notepad++ and change it to my desired form and save it as UTF-8 like this:

enter image description here

but when open it it in Notepad it is in completely different form?

In notepad++ I replaced \t|\t by \n1and also try `\p`1 etc, I have same problem in UltraEdit too, how can I solve it?

  • text3 in notepad text1 text3 – alireza Jul 27 '14 at 16:44
  • Can you provide the original file from Excel (the .xls file) and provide us with the information to make the text file? – LDC3 Jul 27 '14 at 17:36
  • i do as this file, but in save as type section select Unicode Text. – alireza Jul 27 '14 at 17:46
  • You want notepad.exe to show the same thing notepad++ does? Can you provide an example of how the form is different. Notepad++ will support more than notepad. If you are using unix line encoding notepad++ will look fine but notepad might squish it onto one line. – Ravenous Jul 27 '14 at 18:14
  • yes, i linked all of file in first comment, this is result.i need to compile final text by other program and if it has wrong form in notepad it can't be compile. the feature which i need exist in notepad and aren't odd that don't support them. – alireza Jul 27 '14 at 18:24

There is a possibility that \n character is used as end of line (EOL) character to represent a new line.

For historical reasons, Windows use two characters CR+LF (\r\n) to represent a new line, while Unix and Linux uses LF (\n).

Since notepad does not recognise \n alone, lines that looks separated in notepad++ becomes on the same line on notepad.

You can open up the file in notepad++, go to Edit > EOL Conversion > Windows Format to change all \n into \r\n, and then you should see the same thing from notepad.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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