Repeating text

gcotterl · Post by **gcotterl** » Fri Nov 28, 2014 4:33 pm

My file contains:

AAAAAAAA 123456
............... 234567
............... 498586
............... 493848
............... 502010
............... 997384
BBBBBBBB 503000
............... 604060
............... 102030
................ 000230
CCCCCCCC 121212
............... 999940
............... 503054
................ 506660

(the dots are really spaces).

How can I carry the first 8 characters down onto subsequent rows so the result is:

AAAAAAAA 123456
AAAAAAAA 234567
AAAAAAAA 498586
AAAAAAAA 493848
AAAAAAAA 502010
AAAAAAAA 997384
BBBBBBBB 503000
BBBBBBBB 604060
BBBBBBBB 102030
BBBBBBBB 000230
CCCCCCCC 121212
CCCCCCCC 999940
CCCCCCCC 503054
CCCCCCCC 506660

ben_josephs · Post by **ben_josephs** » Fri Nov 28, 2014 7:24 pm

Find what: ^([^_].{7})_(.*)\n_+ [Replace the underscores with spaces]
Replace with: $1_$2\n$1_ [Replace the underscores with spaces]

[X] Regular expression

Replace All -- do this repeatedly until it beeps

gcotterl · Post by **gcotterl** » Fri Nov 28, 2014 9:34 pm

Wow! That worked!! Thanks muchly!!!