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

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.

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

thanks guys both solutions worked a treat