Community
    • Login

    Not changing "|" to tabs when importing .txt

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    5 Posts 3 Posters 1.2k Views 1 Watching
    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.
    • João CairesJ Offline
      João Caires
      last edited by João Caires

      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.

      Alan KilbornA Meta ChuhM 2 Replies Last reply Reply Quote 0
      • Alan KilbornA Offline
        Alan Kilborn @João Caires
        last edited by

        @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
        • Meta ChuhM Offline
          Meta Chuh moderator @João Caires
          last edited by Meta Chuh

          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
          • João CairesJ Offline
            João Caires
            last edited by João Caires

            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
            • João CairesJ Offline
              João Caires
              last edited by

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

              Thanks for the help guys!!

              1 Reply Last reply Reply Quote 2

              Hello! It looks like you're interested in this conversation, but you don't have an account yet.

              Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

              With your input, this post could be even better 💗

              Register Login
              • First post
                Last post
              The Community of users of the Notepad++ text editor.
              Powered by NodeBB | Contributors