Text Parsing Question

[overrider]

Hello all,

i have a textfield containing two strings

"the quick brown [fox jumps over] the lazy dog" . how can i best parse out the content between the [ ] characters? until now i have come up with

Middle ( string ; Position ( string ; "[" ; 1 ; 1 ) + 1 ; ( Position ( string ; "]" ; 1 ; 1 ) - Position ( string ; "[" ; 1 ; 1 ) -1 ) )

, is that the best solution? how can i fix this, so that in case there are more than one ] in the string, all but the last ] are converted to some other character, say * ?

Edited October 11, 2006 by Guest

[BobWeaver]

Let([

C=PatternCount(string;"]")

];

Middle ( string ; Position ( string ; "[" ; 1 ; 1 ) + 1 ; ( Position ( string ; "]" ; 1 ; C ) - Position ( string ; "[" ; 1 ; 1 ) -1 ) )

)