Answered

How to remove some text from a variable with a fixed format, but a differance value? Regular Expression?

(0) Share

Report

Posted on by HAKHBIZ

I get the html from a webpage and put it in a variable. I would like to remove some piece of text from this variable but it has a fixed format, but a difference value. Maybe with an replace action with a regular expression?

See 2 examples below:

const token = 'CfDJ8OrUC3DsyKZIhOQxh1idLV9wBJoGSwvkPZoiB2ItoPEdAqIxvD8K9nsyQ0epSLR5FFw3FEu-lCxaNapQuShNu7adPqU8r4EZ5e-ECS2uXCfZEvCWHQxnlzQ6_AazsBtiLlOFubK8bpx72PW1n80SmwS4u12RD97--rkmK9uSRoinLadgUKZYWGHDv_Y_vUfX2Q';

const token = 'CfDJ8OrUC3DsyKZIhOQxh1idLV_XdK8hGQ9U2aCK61qKciKz4XC-ridoR5AF4BQSC4zbGc2ABuVis7buEp-OBNFxaZJ3KRq5Fp9Ra3RAHgTCyOGqvkqnkF4eq-kJj0bC_yms3ou7Fidj0Mk5sKunKc2VjM7RV9nio5qpLzeakKBNM4VV0YV1sj9_TzryTMhpTLzAyA';

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@khhaj
Indeed, you're correct. You can achieve that by utilizing the Replace action. Simply specify what you want to remove directly within your source text using the replace action.

Additionally, as you mentioned, we can also utilize regular expressions for this purpose.
In case if you require any further help, Please let me know.

----------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No
HAKHBIZ 85 on at

Like (0)

Report
Copy link

Link copied!

@Deenuji I would like to remove this whole text. Do you know which regular expression?

Before variable text:

<div>some html</div>

const token = 'CfDJ8OrUC3DsyKZIhOQxh1idLV9wBJoGSwvkPZoiB2ItoPEdAqIxvD8K9nsyQ0epSLR5FFw3FEu-lCxaNapQuShNu7adPqU8r4EZ5e-ECS2uXCfZEvCWHQxnlzQ6_AazsBtiLlOFubK8bpx72PW1n80SmwS4u12RD97--rkmK9uSRoinLadgUKZYWGHDv_Y_vUfX2Q';

<div>some html</div>

After variable text:

<div>some html</div>

<div>some html</div>

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@khhaj
Follow the below suggestion with regex value:

Regex value: const\s+\w+\s+=\s+'.*?';

--------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No
HAKHBIZ 85 on at

Like (0)

Report
Copy link

Link copied!

Many thanks. I make a mistake. It should be this part of text. How should the regex look like?

<input name="__RequestVerificationToken" type="hidden" value="CfDJ8OY4FYnSf9VPtqYcgBx1yo37SrZp8VKbPkGSiE6d4OgU2q9HjleE_9LZSPB-UwPKu9ThNo_XZAj9-MJmEzfpkKgXaXopWCdmbTIcIQp5HdXM-ewXKSq6KKjv1t0wdWi4U8gPm_e2vDZn7p9gWM7UpbzS0yZ7RdQbbxCKAaVR37x3tSViODpeH62n-qjeLWGHFg">

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@khhaj
Sure, not a problem. Please modify the regex as follows: I have replaced the entire value attribute with an empty string. If you wish to retain value="" in your input tag then mention that in the replace-with parameter.

Regex Used: value="[^"]*"

Output:
Code:
SET NewVar TO $'''<input name=\"__RequestVerificationToken\" type=\"hidden\" value=\"CfDJ8OY4FYnSf9VPtqYcgBx1yo37SrZp8VKbPkGSiE6d4OgU2q9HjleE_9LZSPB-UwPKu9ThNo_XZAj9-MJmEzfpkKgXaXopWCdmbTIcIQp5HdXM-ewXKSq6KKjv1t0wdWi4U8gPm_e2vDZn7p9gWM7UpbzS0yZ7RdQbbxCKAaVR37x3tSViODpeH62n-qjeLWGHFg\">'''
# Remove complete Value attribute
Text.Replace Text: NewVar TextToFind: $'''value=\"[^\"]*\"''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''%''%''' ActivateEscapeSequences: False Result=> Replaced

----------------------------------------------------------------------------------------------------------------------------
If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No