Search found 7 matches

by drlittle
Mon Jun 10, 2013 11:25 am
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Find what: (.{72})(.+)(\n)((?s:.)*?\n)(\n) Replace with: $1$3$4$2$3$5 [X] Regular expression Replace All -- do this repeatedly until it beeps This works, I will need to Macro this as I have over 200 pages; a lot of F8's! Thanks for your patients. I will improve my forum skills. Regards, Dave
by drlittle
Mon Jun 10, 2013 2:07 am
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Sorry for the delayed response. I tried several variation of your suggested RegEx patterns. The results wer not as expected. I tried to submit a better example of Source and Desired Results. A Lot of copy/Paste. Indexed column Data Sets should be in a single column.
by drlittle
Sun Jun 09, 2013 7:41 pm
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

The Z001 to Z020 are the Anchor points, the underlying data was a multiple "paste" to Save time.
by drlittle
Sun Jun 09, 2013 6:24 pm
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Sorry to waste the forum time with a poorly worded request and Example of Source Text and desired Output Text. Confusion with <cr> vs /n - could not determine from looking at Text Pad. View modes and descriptions are a little weak here. Sequence 1-20 in two columns YZZV: ----> RZZ AZY X7-QUA 29 ...
by drlittle
Sun Jun 09, 2013 3:37 pm
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Para Tags

Apologies, should have been 3 blank lines (3 CR's)
by drlittle
Sun Jun 09, 2013 2:25 pm
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Test Data

Right Column does not line up with Left Column, Right Column needs to be placed below Left Column. 3 CR Tags between Pages YZZV: ----> RZZ AZY X7-QUA 29, 207X 7X7 YZZV PZRRRABZ YZZV: ----> RZZ AZY X7-QUA 29, 207X 7X7 YZZV PZRRRABZ CZY VQ CZUBB CPZ ZRZ CVPB ZRRB YBP BRAC Z BYBP BCUBY BZYB BYP CZY VQ ...
by drlittle
Sat Jun 08, 2013 2:31 pm
Forum: General
Topic: Macro Expert Needed! Convert two Columns into one
Replies: 16
Views: 2141

Macro Expert Needed! Convert two Columns into one

I have a text document with a line length of 141 characters. It is actually two columns. I need to convert to one column at character position 73 on a page basis, there are three para tags between pages. Sample page and offline if appropriate.