Unanswered

Remove/delete text between attribute/section in Power Automate Desktop

(0) Share

Report

Posted on by ralphloszak

Anyone have an idea how I can remove all the text in a file between a specific section/attribute using Power Automate Desktop?

For example:

<Section.01>text that I need to remove</Section.01>

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@ralphloszak Yes, I can see two actions which you can use if the file is xml, I could not find any other action to remove/extract a specific text from the file

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Regex will pull it out.
Unfortunately Ive yet to practice getting the middle of a string, just the start or the end at the moment.
I think Regex is the way to go on this occasion

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Behold! Removing text between two text segments:

SET Text TO $'''<Section.01>text that I need to remove</Section.01>''' Text.Replace Text: Text TextToFind: $'''(?<=<Section.01>).+(?=</Section.01>)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Replaced

(copy and paste the code into PAD)

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Henrik !!! Where have you been lol.
Ive just spent a half hour messing with capture groups lol.
Perfect code, I checked it for you 😄

Was this reply helpful? Yes No
ralphloszak 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the code, just started using Power Automate. Will this code work on any text between the two sections <Section.01>this text changes every day</Section.01>? Can you show me a screenshot of what this would look like in PAD?

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

As Henrik said, just copy and paste the text into pad and the actions will magically appear.
Yes it will work with any text between the 2 sections.
Go here https://regexr.com/
Put Henriks code in the top text box and the text you want to work on in the bottom, you can then replace the text between the sections with whatever you want and it will still work regardless.

Was this reply helpful? Yes No
ralphloszak 4 on at

Like (0)

Report
Copy link

Link copied!

WOW, ok that easy, did not expect that. Got that working. What about if the text between the two sections is multiple sentences with commas, periods, and other special characters? I think I need to change something.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Go to the web link I provided and try it out yourself, replace the inner text with whatever may come up in the future...

Was this reply helpful? Yes No