Community
    • Login

    Merging or Joining every 7 lines in a text file using notepad++

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    3 Posts 3 Posters 596 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.
    • Robert BakerR Offline
      Robert Baker
      last edited by

      EMAIL: swmorton50@gmail.com
      CALLSIGN: AA4TI
      NAME: STEPHEN MORTON
      ADDRESS: 5644 CANTUCCI STREET
      ADDRESS-CITY: NOKOMIS
      ADDRESS-STATE-PROVINCE: FL
      ADDRESS-POSTALCODE: 34275
      EMAIL: robertumpleby@tx.rr.com
      CALLSIGN: AA5AH
      NAME: ROBERT UMPLEBY
      ADDRESS: 1209 N WATERVIEW DR
      ADDRESS-CITY: RICHARDSON
      ADDRESS-STATE-PROVINCE: TX/DALLAS
      ADDRESS-POSTALCODE: 75080
      EMAIL: aa5au@bellsouth.net
      CALLSIGN: AA5AU
      NAME: DON HILL
      ADDRESS: 2121 SUTHERLAND PLACE
      ADDRESS-CITY: HARVEY
      ADDRESS-STATE-PROVINCE: LA
      ADDRESS-POSTALCODE: 70058
      EMAIL: rickmaxey51@yahoo.com
      CALLSIGN: AA5TL
      NAME: RICHARD MAXEY, JR.
      ADDRESS: 19708 MAHOGANY ST
      ADDRESS-CITY: BEND
      ADDRESS-STATE-PROVINCE: OR
      ADDRESS-POSTALCODE: 97702
      EMAIL: AA1SU@arrl.net
      CALLSIGN: AA1SU
      NAME: PAUL N. GAYET
      ADDRESS: 11 CHERRY STREET
      ADDRESS-CITY: ESSEX JUNCTION
      ADDRESS-STATE-PROVINCE: VT
      ADDRESS-POSTALCODE: 05452
      EMAIL: skeeter_1@yahoo.com
      CALLSIGN: AA3C
      NAME: RICHARD PETERS
      ADDRESS: 945 BEECHWOOD DR.
      ADDRESS-CITY: MURPHY
      ADDRESS-STATE-PROVINCE: TX
      ADDRESS-POSTALCODE: 75094

      I have a .txt file as above and I want to merge every 7 lines into one. Maybe some one can help me with this

      1 Reply Last reply Reply Quote 0
      • Alan KilbornA Offline
        Alan Kilborn
        last edited by Alan Kilborn

        You might try:

        Open the Replace dialog by pressing Ctrl+h and then set up the following search parameters:

        Find what box: (?-s)(.+)\R(.+)\R(.+)\R(.+)\R(.+)\R(.+)\R(.+)(?=\R)
        Replace with box: \1 \2 \3 \4 \5 \6 \7
        Search mode radiobutton: Regular expression
        Match whole word only checkbox: unticked (and disabled)
        Wrap around checkbox: ticked
        . matches newline checkbox: doesn’t matter (because the (?-s) leading off the Find what box contains an s variant)

        Then press the Replace All button.

        After the replacement, take care that the last grouping of 7 lines is done correctly. Adjust manually if necessary.

        1 Reply Last reply Reply Quote 1
        • guy038G Offline
          guy038
          last edited by

          Hello, @robert-baker, @alan-kilborn, and All,

          An other solution could be :

          SEARCH (?-i)\R+(?!EMAIL|\z)

          REPLACE \x20

          This alternate solution does not mind if additional line-break separates each section ;-))

          For instance, the input text :

          EMAIL: swmorton50@gmail.com
          CALLSIGN: AA4TI
          NAME: STEPHEN MORTON
          ADDRESS: 5644 CANTUCCI STREET
          ADDRESS-CITY: NOKOMIS
          ADDRESS-STATE-PROVINCE: FL
          ADDRESS-POSTALCODE: 34275
          
          
          
          EMAIL: robertumpleby@tx.rr.com
          CALLSIGN: AA5AH
          NAME: ROBERT UMPLEBY
          ADDRESS: 1209 N WATERVIEW DR
          ADDRESS-CITY: RICHARDSON
          ADDRESS-STATE-PROVINCE: TX/DALLAS
          ADDRESS-POSTALCODE: 75080
          
          EMAIL: aa5au@bellsouth.net
          CALLSIGN: AA5AU
          NAME: DON HILL
          ADDRESS: 2121 SUTHERLAND PLACE
          ADDRESS-CITY: HARVEY
          ADDRESS-STATE-PROVINCE: LA
          ADDRESS-POSTALCODE: 70058
          
          
          EMAIL: rickmaxey51@yahoo.com
          CALLSIGN: AA5TL
          NAME: RICHARD MAXEY, JR.
          ADDRESS: 19708 MAHOGANY ST
          ADDRESS-CITY: BEND
          ADDRESS-STATE-PROVINCE: OR
          ADDRESS-POSTALCODE: 97702
          EMAIL: AA1SU@arrl.net
          CALLSIGN: AA1SU
          NAME: PAUL N. GAYET
          ADDRESS: 11 CHERRY STREET
          ADDRESS-CITY: ESSEX JUNCTION
          ADDRESS-STATE-PROVINCE: VT
          ADDRESS-POSTALCODE: 05452
          EMAIL: skeeter_1@yahoo.com
          CALLSIGN: AA3C
          NAME: RICHARD PETERS
          ADDRESS: 945 BEECHWOOD DR.
          ADDRESS-CITY: MURPHY
          ADDRESS-STATE-PROVINCE: TX
          ADDRESS-POSTALCODE: 75094
          
          
          
          

          would output :

          EMAIL: swmorton50@gmail.com CALLSIGN: AA4TI NAME: STEPHEN MORTON ADDRESS: 5644 CANTUCCI STREET ADDRESS-CITY: NOKOMIS ADDRESS-STATE-PROVINCE: FL ADDRESS-POSTALCODE: 34275 
          EMAIL: robertumpleby@tx.rr.com CALLSIGN: AA5AH NAME: ROBERT UMPLEBY ADDRESS: 1209 N WATERVIEW DR ADDRESS-CITY: RICHARDSON ADDRESS-STATE-PROVINCE: TX/DALLAS ADDRESS-POSTALCODE: 75080 
          EMAIL: aa5au@bellsouth.net CALLSIGN: AA5AU NAME: DON HILL ADDRESS: 2121 SUTHERLAND PLACE ADDRESS-CITY: HARVEY ADDRESS-STATE-PROVINCE: LA ADDRESS-POSTALCODE: 70058 
          EMAIL: rickmaxey51@yahoo.com CALLSIGN: AA5TL NAME: RICHARD MAXEY, JR. ADDRESS: 19708 MAHOGANY ST ADDRESS-CITY: BEND ADDRESS-STATE-PROVINCE: OR ADDRESS-POSTALCODE: 97702
          EMAIL: AA1SU@arrl.net CALLSIGN: AA1SU NAME: PAUL N. GAYET ADDRESS: 11 CHERRY STREET ADDRESS-CITY: ESSEX JUNCTION ADDRESS-STATE-PROVINCE: VT ADDRESS-POSTALCODE: 05452
          EMAIL: skeeter_1@yahoo.com CALLSIGN: AA3C NAME: RICHARD PETERS ADDRESS: 945 BEECHWOOD DR. ADDRESS-CITY: MURPHY ADDRESS-STATE-PROVINCE: TX ADDRESS-POSTALCODE: 75094 
          

          Best Regards,

          guy038

          1 Reply Last reply Reply Quote 1

          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