Duane,
Your Macro worked great until I was thrown a new curve. The example I
posted above concatenates flawlessly until I add data from the real
text file (pasted below). I had been using individual recorded macros
to separate the rest of the data but tried to use this new method you
showed me all at once. Now I’m even more lost. Here is the data and
what I’m trying to accomplish:
Raw Data:
==========PDI=G004 Result==========
PDI Number: G004
Finding Category: CAT II
Reference: UNIX STIG: 3.2.1
Description: Passwords can be changed
For example:
alberaz:*LK*:::::::
==========PDI=G015 Result==========
PDI Number: G015
Finding Category: CAT II
Reference: UNIX STIG: 3.1.3
For example:
The SLEEPTIME variable is not set in
==========PDI=G018 Result============
…

Manual End Result (table; top row is column heading)
|PDI Number|-------|Finding
Category|------|Reference|------|Description---|------|For Example|
|G004--------|-------|CAT II------------|------|UNIX STIG|-----|An
Account ...|------|alberaz:*LK*:::::::|


--
AwkSed2Excel
------------------------------------------------------------------------
AwkSed2Excel's Profile: http://www.excelforum.com/member.php...o&userid=23464
View this thread: http://www.excelforum.com/showthread...hreadid=374110