Using Find() on a text file.

[111StepsAhead]

I have a text file of data and I need to remove a subset of the data into excel. For example, I might have a 500 kb file with the specific word "[the_car_color]" and need to extract the word that comes right after it. What's an easy way to do this?

Some code I've found at http://stackoverflow.com/questions/1...eas-close-file

Please Login or Register  to view this content.

The above code replaces the text I'm looking for. It doesn't extract it to excel like I need.

EDIT: I won't needlessly bump this thread since the error was a spelling mistake.

[patel45]

can you attach a sample txt file for testing ?

[HaHoBe]

Hi, 111StepsAhead,

maybe loop and use InStr for each input to decide whether to put the data into the cells or not:

Please Login or Register  to view this content.

Ciao,
Holger

[snb]

If you want the first word after '[the car colour]' in file G:\OF\example.txt a oneliner will do:

Please Login or Register  to view this content.

[111StepsAhead]

snb,

Your code does not work for me. I'm comparing what you did to the split() function http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx and I'm not seeing what you are trying to do. Can you elaborate or clarify your code?

[patel45]

maybe

Please Login or Register  to view this content.

[snb]

Did you adapt the filename in the code ?
Are you sure the file contains the string "[the car colour]" ? (brackets included)

[111StepsAhead]

snb, you missed an "s" in your code. It worked great after that. (sytem should be system)

[snb]

I agree that every sytem should be a system...