parse text between two words using vbscript 1

[jasonhuibers]

My string contains: The dog walked across the street.

How can I parse this string and only return walked across ..

Take only words between dog and street.

 

[ChrisHirst]

The words between dog and street will actually be "walked across the"

Use instr(sentence,word) to get the first split position.


Use instrrev(sentence,word) + len(word) to get the end split position.


mid(sentence,start,end)

Or you could make it into a useful "slice" function.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum