Taking specific text from a document

[dode74]

Hey all

I know this is an excel forum but I've been lurking for a while and I need help with some text issues.

I need the ability to take out from a text file any lines which start with a certain text and put those lines into a separate document. All the lines I want start with the text

 |  | Chat:

and I want only those lines taken into a new text document.

Any ideas?

 

[pgc01]

Hi
Welcome to the board

Not enough information, but maybe:

- open the file
- use autofilter and filter the lines that contain "chat:"
- select the visible rows and copy them elsewhere

 

[taurean]

Maybe this will also help you if you are looking for a code.
http://www.vbaexpress.com/forum/showthread.php?t=36453

 

[dode74]

pcg01 - I'm actually embarrassed not to have thought of that myself - works perfectly.

taurean - thanks. I'll take a look at that to see if I can streamline the process.

 

[pgc01]

I'm glad it helped. Cheers!