Merging or Joining every 7 lines in a text file using notepad++
-
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: 75094I have a .txt file as above and I want to merge every 7 lines into one. Maybe some one can help me with this
-
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 ansvariant)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.
-
Hello, @robert-baker, @alan-kilborn, and All,
An other solution could be :
SEARCH
(?-i)\R+(?!EMAIL|\z)REPLACE
\x20This 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: 75094would 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: 75094Best Regards,
guy038
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