Hello All,

Trying to import a text file into excel to create a table. It looks something like this:

BEGINSUB EXAMPLE
BEGINSUB EXAMPLE_2
*PURPOSE: THIS IS AN EXAMPLE PURPOSE STATEMENT
#Variable=countrec("!/document:Document/xxx")
#Variable2 = GETOVFLWSYM("XML","QCBVEHCOLLAPSSYM") + 1;
What I want to do is create a new row every time "BEGINSUB" appears. Then I want to create a column in that row for each of the following:

-PURPOSE (if it appears)
-XML Nodes (noted by "!/document", "!document", "ns", or "/ns")
-FLWSYM

If there are multiple lines of XML code, then I want a column for each one. Ideally I could have the VBA code add a column if necessary.

If something doesn't appear after BEGINSUB (like PURPOSE, then it leaves that column blank and looks to insert the next line into the appropriate header column)

I hope this is a good explanation of what I'm looking for. Please ask questions for any clarification needed. And help is very much appreciated!!! :D

Thanks and Cheers,
Jamie