Copy text from text file between keyword in rows.

[ucan]

I have a text file and I want to copy all text/numbers/special characters whatever is there between the keyword (". keyword:" and ". keyword:")
Each row cell data must have the first line where the keyword ". keyword:", appears but exclude that (keyword: ". keyword:" ) in last line because next file data will start from there. The last line of the file do not have a keyword. the sample txt file is zipped and excel file has the example output.

[Aussiebear]

How is this different (other than a better presentation) from the other version you asked?

[arnelgp]

you run getTextContent() from Module1.

[ucan]

Thank you. The VBA works great.
But I need the output in excel file same as in text file. Please check the Row 3 and 4 data (first two short lines should be together as in the text file).


you run getTextContent() from Module1.

[Aussiebear]

Awaiting a response from the OP.