Finding words

[Heathbo]

How do you write a script that will set a text field to a word or words found in the middle of a sentence. For example, Say I have a text field with the words John, James, Bill, Ed, Brian. How would I write the script so it will set a text field to the words in-between James, and Brian. James, and Brian will always stay the same.

[Genx]

... id say use a calc...

MiddleValues(

substitute(Substitute(textfield;

"James," ; ¶ );

"Brian." ; ¶ ) ;

2; 1)

hope that helped... if it doesnt work, make an extra field for the substitute bit...

genx

Edited February 11, 2006 by Guest
forgot a semi-colon

[Heathbo]

OK, what if I just want to find the word in-between the HTML tags and ? The HTML is put into a field titled Web Content.