• Login
Community
  • Login

Not changing "|" to tabs when importing .txt

Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
5 Posts 3 Posters 880 Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J
    João Caires
    last edited by João Caires Feb 13, 2019, 1:56 PM Feb 13, 2019, 1:53 PM

    Hello!

    When I import a .txt file, notepad++ is changing the “|” to tabs. Is there a way to change it?
    The only way I found to keep the “|” is to to copy and paste the whole text from the file from notepad to notepad++.

    I need the “|” to keep the structure as close as the original file.

    Also when I import the file, it kills the “0” from the left of the numbers and change the big numbers to cientific notation… Not wanted behaviour.

    Sorry for the noob question.

    Thanks.

    A M 2 Replies Last reply Feb 13, 2019, 2:21 PM Reply Quote 0
    • A
      Alan Kilborn @João Caires
      last edited by Feb 13, 2019, 2:21 PM

      @João-Caires said:

      …changes the big numbers to scientific notation

      Uh, yea…there is no possible way that Notepad++ is doing that. You are probably looking at your data some other program first that is showing you the numbers without scientific notation, but scientific notation is used when saving the “text” version to disk (by whatever originally did the saving). Notepad++ opens the “text” version and shows you what is there, textually, not numerically.

      1 Reply Last reply Reply Quote 3
      • M
        Meta Chuh moderator @João Caires
        last edited by Meta Chuh Feb 13, 2019, 2:24 PM Feb 13, 2019, 2:23 PM

        welcome to the notepad++ community, @João-Caires

        i am not sure, if you are referring to “paste” when you say “import”, but if yes, and you copied something from a web browser or another program to your clipboard:

        try using edit > paste special > paste binary content in notepad++.

        note: if paste binary content is not working for your case, we would need a detailed example how and exactly what you were importing, to be able to reproduce your experience.

        1 Reply Last reply Reply Quote 3
        • J
          João Caires
          last edited by João Caires Feb 13, 2019, 5:00 PM Feb 13, 2019, 4:59 PM

          Thanks for replying guys!

          The flow is the following: I extract some data from the ERP as .txt file with “|” separating the columns.

          When I open the file with the windows notepad, it displays as it should, and in the notepad++ ir changes the characters.

          Check this comparisson: -> image

          But when I copy and paste from notepad to notepadd++, it appears to work just fine.

          1 Reply Last reply Reply Quote 0
          • J
            João Caires
            last edited by Feb 13, 2019, 5:24 PM

            It just worked… I think I was importing the wrong file xD

            Thanks for the help guys!!

            1 Reply Last reply Reply Quote 2
            5 out of 5
            • First post
              5/5
              Last post
            The Community of users of the Notepad++ text editor.
            Powered by NodeBB | Contributors