topic RE: Extract values from Collection Field in Product Forum

Extract values from Collection Field

AndreKöpplin — Tue, 21 Mar 2023 15:39:00 GMT

Dear Community

I want to extract below information from a Collection field, which I got via APIRest Call. This information is incl. in a HTML code, because this is a Message, which incl. Pictures and hyperlinks.

Requestor (line manager):
Requestor (line manager) ID:
Impacted employee:
Impacted employee ID:
Required action:
Document type:
Reason of issue: At request of customer
Letter language: German

Examle (shorted):

"fdgargtasdgwergtre4tgdgrgergdfgdfgdfgfgdfgdfgdfgfgdfgfgf Requestor (line manager): Name Surname Requestor (line manager) ID: 12345678 Impacted employee: Name Surname Impacted employee ID: 132346697 Required action: Reference must be prepared Document type: DocumentTitle Reason of issue: At request of employee Letter language: German fdgargtasdgwergtre4tgdgrgergdfgdfgdfgfgdfgdfgdfgfgdfgfgf "

I tried to use the VBO Utility - Regrex, but everything, which I tried and found in the Internet failed.

Thanks for help.

Andre

Blue Prsim Version: 6.10

------------------------------
Andre Köpplin
RPA Project Manager
Europe/Wroclaw
------------------------------

RE: Extract values from Collection Field

Mukeshh_k — Tue, 21 Mar 2023 19:31:00 GMT

Hi Andre Köpplin, Please refer below steps to solve your query -

Use Utility String - Retrieve Regex Match : "Requestor \(line manager\):\s*([A-Za-z]+\s[A-Za-z]+)\s*(?:<br\s*\/?>\s*|,)\s*Requestor \(line manager\) ID:\s*(\d+)\s*(?:<br\s*\/?>\s*|,)\s*Impacted employee:\s*([A-Za-z]+\s[A-Za-z]+)\s*(?:<br\s*\/?>\s*|,)\s*Impacted employee ID:\s*(\d+)\s*(?:<br\s*\/?>\s*|,)\s*Required action:\s*(.*?)\s*(?:<br\s*\/?>\s*|,)\s*Document type:\s*([A-Za-z]+)\s*(?:<br\s*\/?>\s*|,)\s*Reason of issue:\s*At request of employee\s*(?:<br\s*\/?>\s*|,)\s*Letter language:\s*([A-Za-z]+)"
Replace Breaks with Comma to make it CSV like Structure
Call Action Get CSV as Collection and Set Output Collection:
Output :

Let me know if you find any difficulties implementing this - You can play around with output collection to set data as per your choice in any defined collection.

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS England, United Kingdom, GB
------------------------------

RE: Extract values from Collection Field

AndreKöpplin — Wed, 22 Mar 2023 06:35:00 GMT

Thanks a lot Mukesh

I am wondering, I can't find the Action "Retrieve Regex Match" in my VBO Utility Strings . Do you have any download link from Blue Prism DX Community?

------------------------------
Andre Köpplin
RPA Project Manager
Europe/Wroclaw
------------------------------

RE: Extract values from Collection Field

plnarayana777 — Wed, 22 Mar 2023 06:46:00 GMT

Hi @AndreKöpplin

Other option as to do as well with Utility - Strings ( Extract Regex Values)

[\<br\s\/>]+[Requestor\(line manager\)\s]+:(?<RequestorName>[\w\s]+)[\<br\s\/>]+Requestor \(line manager\)\sID:(?<RequestorID>.*)\ Impacted employee:(?<ImpactedEmployee>.*)\ Impacted employee ID:(?<ImpactedEmployeeID>.*)\ Required action:(?<RequiredAction>.*)\ Document type:(?<DocumentType>.*)\ Reason of issue:(?<ReasonofIssue>.*)\ Letter language:(?<Letterlanguage>[\w\s]+)\

Build one collection with the group names as below

Output will as this

Note - Group names should not contain spaces

Hope this will help

Regards

------------------------------
Lakshmi Narayana
------------------------------

RE: Extract values from Collection Field

plnarayana777 — Wed, 22 Mar 2023 06:48:00 GMT

for latest VBO you can find in DX portal Blue Prism Digital Exchange

Regards

------------------------------
Lakshmi Narayana
------------------------------

RE: Extract values from Collection Field

AndreKöpplin — Wed, 22 Mar 2023 09:39:00 GMT

Hello Lakshmi

Thanks a lot, with your help, I found my issues in the Regex Patern and I got my data from the HTML Text.

Thanks a lot also to Mukesh, I see, I have to update our Utilities.

------------------------------
Andre Köpplin
RPA Project Manager
Europe/Wroclaw
------------------------------