Hi Everyone,
I need some help from Regex masters. I want 4 separate Regex which extract Column “Actual” value for me according table name.
Hi Raja,
Can you share how the extracted data looks like?
Dear Ahmed,
Thank you so much. Data look like this.
Service Level Report for BESIX CONSTRUCT L.L.C For October 2022 to December 2022
Uptime
Option
Description
Service Type Media
Service details Comments
Committed Actual Status
DPI Basic Availability
100.00 % Complied 900102711890_DPI - DPI - Main - Besix
construct LLC Basic IDA Fiber/- Basic 99
Uptime
Option
Description
Service Type Media
Service details Comments
Committed Actual Status
DPI Basic Jitter
79.44 % Violated 900102711890_DPI - DPI - Main - Besix
construct LLC Basic IDA Fiber/- Basic 95
Uptime
Option
Description
Service Type Media
Service details Comments
Committed Actual Status
DPI Basic Latency
98.94 % Complied 900102711890_DPI - DPI - Main - Besix
construct LLC Basic IDA Fiber/- Basic 95
Uptime
Option
Description
Service Type Media
Service details Comments
Committed Actual Status
DPI Basic Packet Loss
99.93 % Complied 900102711890_DPI - DPI - Main - Besix
construct LLC Basic IDA Fiber/- Basic 95
Section 1 - SLA Status
24/02/2023 15:07:08 +0400 Page 3 of 38.
Got it @raja.arslankhan
You can use below regex:
(?<=Latency\s)(.*?(?=%))
Simply Replace Latency with other values and you’ll get the respective %
Hi @raja.arslankhan ,
Could you try Setting the PreserveFormat Property of the Read PDF Text Activity to True and then provide us the Extracted Data ?
@ahmad.sultan Thank you so much. Let me check
@supermanPunch Thank you so much for reply, I am using old version of UiPath and in pdf package “Read pdf text” their is no such property.
@supermanPunch please check this one:
Service Level Report for BESIX CONSTRUCT L.L.C For October 2022 to December 2022 Section 1 - SLA Status DPI Basic Availability Service details Uptime Comments
Description
Service Type Media Option Committed Actual Status 900102711890_DPI - DPI - Main - Besix Basic IDA Fiber/- Basic 99 100.00 % Complied
construct LLC DPI Basic Jitter Service details Uptime Comments
Description
Service Type Media Option Committed Actual Status 900102711890_DPI - DPI - Main - Besix Basic IDA Fiber/- Basic 95 79.44 % Violated
construct LLC DPI Basic Latency Service details Uptime Comments
Description
Service Type Media Option Committed Actual Status 900102711890_DPI - DPI - Main - Besix Basic IDA Fiber/- Basic 95 98.94 % Complied
construct LLC DPI Basic Packet Loss Service details Uptime Comments
Description
Service Type Media Option Committed Actual Status 900102711890_DPI - DPI - Main - Besix Basic IDA Fiber/- Basic 95 99.93 % Complied
construct LLC 24/02/2023 15:07:08 +0400
Hi @raja.arslankhan ,
Use below regex to get all percentage
/100(\.[0]{1,2})?|([0-9]|[1-9][0-9])(\.[0-9]{1,2})? %
Refer below link
Regards,
Arivu
Hi @raja.arslankhan , Check this below attached workflow,
Uipath_RegexExtraction_BasedOnTable.xaml (9.0 KB)
Hope this may help you 
4 Likes
Hello @raja.arslankhan , Kindly find the Regex pattern
(?<=Basic\sAvailability\n).*(?=\%)
(?<=Basic\sJitter\n).*(?=\%)
(?<=Basic\sLatency\n).*(?=\%)
(?<=Basic\sPacket\sLoss\n).*(?=\%)
