Community
    • Login

    How to make all data in one line

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    3 Posts 2 Posters 273.9k Views 2 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.
    • djmcgD Offline
      djmcg
      last edited by

      Hello .
      I have txt file with example 1000 line I would like to have all of them in on line.
      It` s possible to use Backspace or delete of end of the line but cost lot of time .
      any ideas?

      1 Reply Last reply Reply Quote 0
      • guy038G Online
        guy038
        last edited by guy038

        Hello, @djmcg,

        Very easy, indeed !

        • Open your file in Notepad++

        • Open the Replace dialog ( Ctrl + H )

        • Check the Wrap around option

        • Choose the Regular expression search mode

        • Fill in the regex (\h*\R)+ in the Find what: zone

        • Fill in the regex \x20 in the Replace with: zone

        • Click on the Replace All button


        Of course, you could have used the two N++ built-in commands Edit > Blank operations > EOL to Space or Edit > Blank operations > Remove Unnecessary Blank and EOL, but :

        • The later command does not merge consecutive Line Break, before changing it by a single Space character

        • The former command acts as the later command and, in addition, does not trim any trailing blank character ( Space or Tab ), before replacing it by a single Space character

        On the contrary, my regex will replace, systematically, any gap between two non-empty lines, with a single Space character :-)) Saying “non-empty lines”, I mean lines containing, at least, one non-blank character !


        Now, if your text contains some words, separated with more than 1 space or with Tabulation characters and than you would like to normalize all these blank characters, between words, to a single Space character, use the following regex S/R :

        SEARCH \h{2,}

        REPLACE \x20


        Notes :

        • The quantifiers :

          • *, or {0,}, means 0 or more times, the preceding character or group

          • +, or {1,}, means 1 or more times, the preceding character or group

          • {2,} means 2 or more times, the preceding character or group

        • \x20 represents any single Space character, of Unicode value \x{0020}

        • \h represents any single Horizontal Blank character :

          • The Space character, ( SP ), of Unicode value \x{0020}

          • The Horizontal Tabulation character, ( HT ), of Unicode value \x{0009}

          • The No-Break Space character( NBSP ) , of Unicode value \x{00A0}

        • \R represents any single New Line sequence :

          • The usual Line Break character(s) :

            • \r\n, of Unicode value \x{000D}\x{000A}, in a Windows file

            • \n, of Unicode value \x{000A}, in a Unix file

            • \r, of Unicode value \x{000D}, in a Macintosh file

          • The Vertical Tabulation character, of Unicode value \x{000B}

          • The Form Feed character, of Unicode value \x{000C}

          • The Next Line character ( NEL ), of Unicode value \x{0085}

          • The Line Separator character, ( LS ), of Unicode value \x{2028}, in a Unicode encoded file

          • The Paragraph Separator character, ( PS ), of Unicode value \x{2029}, in a Unicode encoded file

        So, to be short :

        • The regex \h is equivalent to the regex [\t\x20\xA0]

        • The regex \R is equivalent to the regex \r\n|[\n\x0b\f\r\x85\x{2028}\x{2029}]

        Best Regards,

        guy038

        1 Reply Last reply Reply Quote 1
        • djmcgD Offline
          djmcg
          last edited by

          Hello guy038
          The first option`s works perfectly.
          Thank You.

          1 Reply Last reply Reply Quote 0

          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