Not sure how to accept a reply, but the $EXTRACT(input,$FIND(input,"(")-1,*) did the trick once I worked out the details of syntax. Thanks again. Now I dive in further over my head to the next "we never did this before" project.

I put the $ in and the code worked. I wound up using this, $EXTRACT(input,$FIND(input,"(")-1,*).

This version does not recognize EXTRACT or FIND.

Is it possible to do a SubString from an index to the end

It seems like they have no function for this.

..ReplaceStr(input,start to "(","(") where I replace everything up to the first parens with just a parens.

This would be so simple, I thought.

Jonathan has no followers yet.
Jonathan has not followed anybody yet.
Global Masters badges:
Jonathan has no Global Masters badges yet.