Copy text file after "phrase" in the text

**fredo** · 04-27-2011, 09:14 PM

G'day
I have a text file that I need to import into Excel. The file is generally about 100,000 lines but I only need the data after the phrase "Adjusted Coordinates". The location of the phrase changes within the text file as more data is added from the program that created it. It is unfortunately not a unique phrase as it is repeated a second time 3 lines later.

I have had a crack at getting this to work but I currently have to manually delete all of the data above "Adjusted Coordinates" and then import it (see below).

I would prefer if the required data can just be extracted from the text file without altering the original file.

Attached is an example of the text file. I have taken a lot of the data out of it to make it a smaller file but I think the same principle should apply.

Thanks in advance

Please Login or Register  to view this content.

**antoka05** · 04-28-2011, 04:26 AM

You could use this macro that creates 'temp.txt' file in the same path of your selected file and then delete it after import:

Please Login or Register  to view this content.

Regards,
Antonio

**pike** · 04-28-2011, 05:33 AM

Hi fredo,
or maybe something like

Please Login or Register  to view this content.

**fredo** · 04-29-2011, 12:50 AM

Thankyou both for you help.

I went with the one Antoka05 suggested as I understang what is happening in each step (still very new to VBA).

I have tried it with the large file (100,000 lines) and it works great.

Thanks again