Importing text using macros to identify tags and merge data into columns

[abousetta]

I have been struggling with a problem that I hope someone can help me with. (Background: I am a novice at VBA and so please bear with me with some of the more complex syntax)

I have an output (attached txt file) that contains a series of tags for each reference (citaiton). The number of tags may vary from one reference to the next, but will always be preceded by a return carriage (blank line) and end with a return carriage. All tags are CAPITAL letters and contain six characters. The first tag will always be "TY - " and the last tag will always be "ER - " .

What I am trying to do is create a new excel sheet with the information (identified by specific tags) merged into one cell. In the dummy excel sheet (attached) I demonstrate that I want to put in the first column the data from the reference id tag ("ID - ") and in the column next to it a merge of tags ("A1 - ","JF - ","Y1 - "), but without the three backslashes ("///") (i.e. just the year without month or day).

Any ideas will be highly beneficial.

Thanks.

Abousetta