2 fields and need to extract variable text

[stann]

Hello

I have 2 fields " fullone" and "variation"

Variation contains a term that is in the text of "Fullone" but it is always in a different place in the line of text.

I am trying to find a calculation that will allow me to grab everything to the left of that word and place that in a field called "model" and everything to the right of that word and put it in a field called "trade"

an example would be " variation = "monster"

"Fullone" = we have created a monster for what it is worth

model ="we have created a "

trade= "for what it is worth"

But it would always be to the left or the right of "Variation"

Thanks

STAN

FileMaker Version: 7

Platform: Mac OS X Panther

[CyborgSam]

Stan->

model's calculation is: Left(Fullone, Position(Fullone, variation, 1, 1) - 1)

trade's calculation is: Right(Fullone, Length(Fullone) - Length(variation) - Position(Fullone, variation, 1, 1))

Sam

[stann]

Thanks for the help - So much I learned from this.