Hi All,
I want to extract "first name", "Last Name", and "URL" from the below text. the text I have converted using html to text action. text highlighted in red is needed.
here is the text :
[https://apc014ca9941912%7C0%7C0%7C638206184187049547%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wJQIjoiV2luzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=1nHhHIH35J3V7S9wX259vha92dwZ8b6oM6bigOcJwU4%3D&reserved=0 ]
From: ENTERPRNG.COM <ENTERPRI.BRING.COM>
Sent: Thursday, May 25, 2023 2:32 PM
To: RCG OSHORE <RCRE@hcl.com>
Subject: Please approve the following form: Offer Form - India -
1267929BR-ASSOCIATE COLTANT : Ethiraj S
[https://trm.brassring.com/clientlogo/hcltechlogo.gif]
Garg, Shefal(31) has eLinked a form for you to approve.
S, Ethiraj
[https://trm.brassring.com/MobInterface/FormApproval.aspx?g=AF1C5FE60E4649BD88518BA306D234D8&c=M5574F32pHy5Ha$bgzac5w== ]
This is a system-generated message. Please do not reply.
Dear Approver,
This is to inform you that the offer for below candidate with the requisition
mentioned is pending for approval.
Kindly approve the offer at the earliest.
Regards,
System Admin
Access your eLink dashboard to review and take action on all your eLinks:
My eLink Dashboard
[https://trm.brag.com/mobile/elinkprofile?q=%5etDCxP6HMyK28UZkeO%2bbjmaH2UcgbiBZX%2fT3zn7OuQgC7hJCQGV9lydSZ6%2fgPRSNI1Uz%2fL5WrHdvqMiBdPnDGZTZ%2fbToVdYDa6grFXMRoM4k%3d ]
Output required :
First Name : S
Last Name: Ethiraj
url : [https://trm.brang.com/MobInterface/FormApproval.aspx?g=AF1C5FE60E4649BD88518BA306D234D8&c=M5574F32pHy5Ha$bgzac5w== ]
Here's the whole flow:
The "NewLine" variable is just a string variable where I hit "enter" in the space, and that's it.
The EmailBody is a copy / paste of what you entered above.
Here are the steps, with the expressions used shown in the notes:
When the emails are always the same, it's pretty easy - you just use "Find Text" first to find the string that precedes the block you need. From there, you just find something to split on, and then trim down to what you need.
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional