Remove the contents within parenthesis

[ajithd6368]

Hi Experts ,

i have a filed in a list its value is like below

CGNHUB(IMPORT)MIPDFG

I need to remove two parenthesis and the content .  basically (IMPORT)  entire string .. The content can be change and the position also .  What exactly i need to do if  open parenthesis is available  then go to the  end parenthesis and remove all .

pls advice 

rgds

AD

[Nived_Nambiar · Accepted solution]

Hi @ajithd6368 

I have shared a simple example on how to do it 

i have stored a value (which u have shared in question) in a variable, now in compose i will write an expression which checks whether there is open parenthesis , if yes , remove parenthesis and inside content , else it will take the variable as is.

expression used :

if(contains(variables('a'),'('),replace(variables('a'),slice(variables('a'),indexOf(variables('a'),'('),add(indexOf(variables('a'),')'),1)),''),variables('a'))

Output obtained after running the flow

Hope it helps 

Mark it as solution if it resolves your query !

[ajithd6368]

Thanks Nived .. it perfectly worked ..

rgds

AD

[ajithd6368]

Hi Nived ,

small issue . I get below error if there is only one parenthesis. Pls advice how to handle this scenario 

flow

rgds

AD

[ajithd6368]

Hi Nived ,

It should remove parenthesis if there is only  one, either open or close parenthesis 

thanks

AD

[Nived_Nambiar]

Hi @ajithd6368 

So in case of one parenthesis, it should remove everything starting from parenthesis , right ?

[ajithd6368]

Hi Nived ,

Appreciated your help on this .

Can we do this way , 

first check whether only one parenthesis exists , if then  skip  the above expression and set a variable indicating that its having a wrong pattern .. then i can update the item in the list with an error .

rgds

AD

[Nived_Nambiar · Accepted solution]

Hi @ajithd6368 

You can use same If expression for to update message saying that string is not in correct format if it has only one parenthesis 

Like below

expression used:

if(and(contains(variables('a'),'('),contains(variables('a'),')')),replace(variables('a'),slice(variables('a'),indexOf(variables('a'),'('),add(indexOf(variables('a'),')'),1)),''),if(or(contains(variables('a'),'('),contains(variables('a'),')')),'Not in correct format',null))

so this code checks first whether it has both closed and open brackets, if yes it will replace the values within parentheis with null, else it will check whether it contains open parentheis or closed one, if yes then it will say Not in correct format, else if does not contain any parenthesis, then it put result as null, which i have higlighted in above expression. You can replace with any other value or the variable itself so that it will display the same value 🙂

Hope it helps !

[ajithd6368]

Thanks Nived , it worked 

appreciated 

rgds

AD