topic RE: How can I extract a text from the Input html element in Product Forum

How can I extract a text from the Input html element

RoshiniSyed — Tue, 17 May 2022 15:12:00 GMT

Hello,

I am trying to extract the name of .png from the below span element

[Data1] =<span style='width: 24px; height: 24px; margin-top: 3px; margin-right: 6px; margin-bottom: 3px; vertical-align: middle; display: inline-block; position: relative; box-sizing: border-box; background-image: url("/assets/icons/service-active.png"); background-size: cover;' data-tb-test-id="StatusGrid-node1-gateway-0"></span>

output should be: service-active.png

[Data1] = <span style='width: 24px; height: 24px; margin-top: 3px; margin-right: 6px; margin-bottom: 3px; vertical-align: middle; display: inline-block; position: relative; box-sizing: border-box; background-image: url("/assets/icons/stopped.png"); background-size: cover;' data-tb-test-id="StatusGrid-node1-gateway-0"></span>
output should be: stopped.png

I tried this, but unable to extract the required output.

Any help would be highly appreciated.

------------------------------
Roshini Syed
------------------------------

RE: How can I extract a text from the Input html element

devneetmohanty07 — Tue, 17 May 2022 16:12:00 GMT

Hi @Roshini Syed,

You can use the following calculation expression and it should work for both of your use cases:

Left(Mid([Data1], InStr([Data1], "url(""/assets/icons/") + Len("url(""/assets/icons/"),InStr([Data1],"""); background-size: cover;")),InStr(Mid([Data1], InStr([Data1], "url(""/assets/icons/") + Len("url(""/assets/icons/"),InStr([Data1],"""); background-size: cover;")),"""); background-size: cover;")-1)

Please find the below results for your reference:

Use Case I:

Use Case II:

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

RE: How can I extract a text from the Input html element

RoshiniSyed — Wed, 18 May 2022 06:39:00 GMT

Hi Devneet,

Thank you for your Prompt reply, getting below error while evaluating expression

Any Suggestions please?

------------------------------
Roshini Syed
------------------------------

RE: How can I extract a text from the Input html element

PabloSarabia — Wed, 18 May 2022 07:47:00 GMT

Hi @Roshini Syed

I try the Devneet's formula and is correct.

Maybe the problem is with the coma (",") against the semicolon (";")

Left(Mid([Data1]; InStr([Data1]; "url(""/assets/icons/") + Len("url(""/assets/icons/");InStr([Data1];"""); background-size: cover;"));InStr(Mid([Data1], InStr([Data1]; "url(""/assets/icons/") + Len("url(""/assets/icons/");InStr([Data1],"""); background-size: cover;"));"""); background-size: cover;")-1)

Hope this helps you!

See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

RE: How can I extract a text from the Input html element

devneetmohanty07 — Wed, 18 May 2022 23:37:00 GMT

Hi Rohsini,

I tried to copy paste my formula again and I faced no errors. I think while copy pasting the formula directly you are getting some enter characters in between. Can you try to remove them and try this once again, this formula should definitely work

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

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

RE: How can I extract a text from the Input html element

RoshiniSyed — Thu, 19 May 2022 05:49:00 GMT

Hi Devneet,

Thank you for your assistance. Definitely will try it out.

------------------------------
Roshini Syed
------------------------------