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.
Log in or create a new account to continue