Function ( "TxtA TxtA TxtA TxtB TxtC TxtA"; "TxtC" ; 1 ; "..

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" ?

On Dec 4, 7:51 am, "Grolo" wrote:
> 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" ?

Trim(Substitute(["TxtA"; ""]; ["TxtC";""]) )

That would give you the correct result, but without more details it's
hard to say if that's what you need.