Text Extraction and Regex challenge

Help Studio
, ,
1

Hi,

I have an issue with regards to extraction information from text file and need help and idea.

I have input as below

Block 11 (Plot 461 - Plot462)= 12 units Block 14 (Plot 601 - Plot624)= 24 units
(Plot 476 - Plot487)= 12 units (Plot 626 - Plot649)= 24 units
Block 12 (Plot 501 - Plot 524)= 24 units Block 15 (Plot 651 - Plot 706) = 56 units

and expected output as

The image shows an Excel spreadsheet displaying blocks, plots, and units information, along with the Excel ribbon menu at the top. (Captioned by AI)
The image shows an Excel spreadsheet displaying blocks, plots, and units information, along with the Excel ribbon menu at the top. (Captioned by AI)860×517 33 KB

How can I extract those info by using Regex ? is that possible to used regex command in this situation.

Thank you

2

Hi @Abang_Jamuri_Abang_Shoker

Can you try this regex:

Block\s?(\d+)\s?(Plot\s?(\d+) - Plot\s?(\d+))\s?=\s?(\d+)\s?units

This expressions gives you all matches and groups. Then you can use the values.

Regards.

3

Hi tolga.kamci

thanks for the reply but could not get the value.

4

The image shows a RegEx Builder application with a regex pattern and its components defined, alongside options for quantifiers and case sensitivity settings. (Captioned by AI)
The image shows a RegEx Builder application with a regex pattern and its components defined, alongside options for quantifiers and case sensitivity settings. (Captioned by AI)1422×891 24.5 KB

This image shows an open UiPath Studio window with a sequence of activities designed to find matching patterns in text and write the output to the console. (Captioned by AI)
This image shows an open UiPath Studio window with a sequence of activities designed to find matching patterns in text and write the output to the console. (Captioned by AI)1920×1080 322 KB

got the error

The image shows a debug window of an automation workflow in development, highlighting an error message "Write Line: Object reference not set to an instance of an object." (Captioned by AI)
The image shows a debug window of an automation workflow in development, highlighting an error message "Write Line: Object reference not set to an instance of an object." (Captioned by AI)1415×672 47.3 KB

5

Hello @Abang_Jamuri_Abang_Shoker

can you try below. It is combination of LINQ and REgex
Use build datatable activity for generating dt_test

dt_test = (From match as System.Text.RegularExpressions.Match in System.Text.RegularExpressions.Regex.Matches(str_Input,"(Block [\d]+)\s\(Plot ([\d]+) \- Plot\s*(\d+)\)\s?=.+?(\d+)").Cast(of System.Text.RegularExpressions.Match) select x = dt_test.LoadDataRow({match.Groups(1).Value,match.Groups(2).Value,match.Groups(3).Value,match.Groups(4).Value},True)).CopyToDataTable

image
image1012×471 18.8 KB

6

Hi AkshaySandhu,

got an error

The image shows a debugging interface with multiple error messages related to code validation issues in a development environment. (Captioned by AI)
The image shows a debugging interface with multiple error messages related to code validation issues in a development environment. (Captioned by AI)1892×980 124 KB

This image shows a workflow process where a file path is being assigned to a variable named , followed by an activity to build a data table and save it to a variable named . (Captioned by AI)
This image shows a workflow process where a file path is being assigned to a variable named , followed by an activity to build a data table and save it to a variable named . (Captioned by AI)1287×325 16.2 KB

The image shows a portion of a UiPath workflow where a text file is read using the "Read Text File" activity, and the content is assigned to a variable in the subsequent "Assign" activity. (Captioned by AI)
The image shows a portion of a UiPath workflow where a text file is read using the "Read Text File" activity, and the content is assigned to a variable in the subsequent "Assign" activity. (Captioned by AI)1339×423 28.3 KB

My edited query

“(From match as System.Text.RegularExpressions.Match in System.Text.RegularExpressions.Regex.Matches(txtline,”(Block [\d]+)\s(Plot ([\d]+) - Plot\s*(\d+))\s?=.+?(\d+)“).Cast(of System.Text.RegularExpressions.Match) select x = dttable.LoadDataRow({match.Groups(1).Value,match.Groups(2).Value,match.Groups(3).Value,match.Groups(4).Value},True)).CopyToDataTable”

Not sure why I got the error

7

do not keep code in double quotes. Directly assign it to dt_test

image
image328×105 2.37 KB

Also try to copy the code from code block that I gave you…
if you face issue with double quotes (as I can see from error message), after pasting the code, replace all double quotes by type it manually.

8

here is xaml file, just incase if you face any issue
Generate_DataTable.xaml (7.7 KB)

1 Like
9

Thanks AkshaySandhu, manage to get the output…

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.