extracting part of a string

[Aussie John]

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

[Vaughan]

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.

[Reed]

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

[Aussie John]

thanks guys both solutions worked a treat