how to extract a string between two others?

[Benka]

Hi

How would you to extract a string between "TxtC" an "TxtA" ("TxtB") with a function like this one

Function ( "TxtA TxtA TxtA TxtB TxtC TxtA"; "TxtC" ; 1 ; "TxtA" ; 1 ) ->

"TxtB" ?

Thanks!

[comment]

Your question is not quite clear. See here for a generic formula to extract text between known prefix and suffix:

http://fmforums.com/forum/showpost.php?post/289685/

If that doesn't solve your problem, please elaborate.