How to delete the content in parentheses
Need help. I have several parentheses in each text string, I would like to delete the contents in parentheses using calculation function. Does anyone know how to do it?
I can delete the content in the first parentheses using the following sentences:
Let ([x=Pedigree; s=Position (x; "(";1;1)-1;e=Position (x;")";1;1) + 1]; TrimAll (Left (x; s) & Right (x; Length (x) -e); 1; 1))
But I don't know how to add loop to get rid of others.