Removing all text between brackets

(0) Share

Report

Posted on by Shafeel_07

Hey Guys ,

i was wondering how can you remove text between multiple brackets and the brackets in flow.

for example : abc[123]def[123]ghi[123]

should end up being: abcdefghi

In a string there can be a number of brackets so want to take this into account as well. Any help you be much appreciated!

Thanks !

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

efialttes 14,756 on at

Like (4)

Report
Copy link

Link copied!

Hi!
LOL, we are discussing almost the same scenario here:
https://powerusers.microsoft.com/t5/General-Power-Automate/Trim-String/m-p/492100#M47010
Let's assume your input string is stored in a string variable called 'myInputString'
I would do the following:
1. Initialize a variable called 'myOutputString', type string value empty
2. Add an 'Apply to each' action block, using the following expression as its input:
split(variables('myInputString'),'[')
Inside the Apply to Each, add a Condition action block:
In the left use the expression: item()
Select 'contains'
On the right add the character: ]

On the true branch, add an Append to String, variable name 'myOutputString', assign as its value the expression:
split(item(),']')[1]

Now on the false branch, add an Append to String, variable name 'myOutputString', assign as its value the expression:
item()

Finallly outside the Apply to each, add a dummy Compose action block, assigning variable myOutputString as its input. Execute the flow and inspect dummy Compose output

Hope this helps

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Shafeel_07

See my example below:

Was this reply helpful? Yes No
Ricardo111 52 on at

Like (0)

Report
Copy link

Link copied!

This works perfectly - complex but took me just 10 minutes. A huge thank you, saves buying a license to a 3rd party parsing tool.

Was this reply helpful? Yes No