[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Find first line FOLLOWING a sequence of matches
From: |
Subhan Michael Tindall |
Subject: |
Find first line FOLLOWING a sequence of matches |
Date: |
Tue, 28 Apr 2015 16:53:58 +0000 |
Table like this: (abbreviated)
|a|b|c|
|a|d|e|
|a|z||
|m|b|c|
|m|c|d|
|ab|c|d|
First col is relevant (actual table is MUCH bigger)
I'm looking to write a macro to convert this table (on an occasionally
recurring basis)
To something like:
,* a
|a|b|c|
|a|d|e|
|a|z||
,* m
|m|b|c|
|m|c|d|
,* ab
|ab|c|d|
The entries in first column are always strings of characters, no internal
whitespace
Looking for a way to search for the LAST match for a given element
With that I should be able to macro-ize my keystrokes and save some time, or
better yet come up with something to fully process the file
EG:
Insert ,* a header
Search for a in column 1
Find the last a in the block
Move down a line
Copy m & insert ,* m header
Search for m in column 1
<repeat>
Thousands of lines, hundreds of blocks, don't make me export this to excel and
do it there!
This message is intended for the sole use of the individual and entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure under applicable law. If you are not the intended
addressee, nor authorized to receive for the intended addressee, you are hereby
notified that you may not use, copy, disclose or distribute to anyone the
message or any information contained in the message. If you have received this
message in error, please immediately advise the sender by reply email and
delete the message. Thank you.
- Find first line FOLLOWING a sequence of matches,
Subhan Michael Tindall <=
Re: Find first line FOLLOWING a sequence of matches, Bob Proulx, 2015/04/30