Jump to content

extracting part of a string


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

Recommended Posts

I know there have been some discussion about extracting text but i couldnt find anything relating specifically to this instance

I have a string with two underscores beyween 3 variable texts

eg

abc_yayay_mmm

the length of the texts vary

I'd like to extract "MMM" part. thanks

Link to comment
Share on other sites

Have you tried the RightWords() function? It'll work if FMP considers the underscore as a word separator. Try it first.

Otherwise you need to locate the Position of the second underscore, then plug that value (minus 1) into the Right function.

Link to comment
Share on other sites

Try creating a calculation field like this one:

 

Let(

[

start=Position ( textField ; "_" ; 1 ; 2 );

length=Length(textField)

];

Right(textField;length-start)

) 

The Let function isn't necessary, it just makes it easier to read. For other types it's much the same, but you might use left() or middle() instead of right.

Dana

Link to comment
Share on other sites

This topic is 6989 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
×
×
  • Create New...

Important Information

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