Parsing Text from a Comment Field

[msakowitz]

I need help in developing a formula that can parse some text from a comment field. I am looking for a way to identify the text to grab based on a particular character.

Example Comment
'Type: Building; Location: 5th Floor Lab; This lab was named for a million dollar donor.'

So, what I would like is to grab either this ('Type: Building; Location: 5th Floor Lab') OR just to grab this ('Type: Building')

your help is greatly appreciated.

 

[lbass]

stringvar array x := split({table.comment},";");
x[1]+
(
if ubound(x)>1 then
";" + x[2]
)

-LB