Jump to content

2 fields and need to extract variable text


This topic is 6489 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6489 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.