Extract Substrings

[alawoona]

Struggling with coding this problem in an elegant manner :

I have a large text file from which I want to extract certain strings. Each string will start immediately after the characters "Clip=" and then end at the character before the next ' (single quote character). There will be a number of these strings within the text file, don't know how many, the string length is variable.

Big thank you if you can help.

[alawoona]

No carriage returns between "Clip=" and the single quote

There are carriage return in the file though.

Edited January 26, 2004 by alawoona

[alawoona]

Thanks Larry - i missed the StingInStr function reading the help file. Am using the script already.----works well.