Regex patten

Help
1

I Have figured out regex pattern - but not sure how to use it in UiPath
Please help me with the package if any need to be installed - would be great if i had some sample workflow

Note : I need to get the values which has marked in blue

regex
regex831×671 24.6 KB

2

Hi,

Create a variable with your regex pattern as

 regexObj As New Regex("([0-9]+) replace this with your pattern ([0-9]+)", RegexOptions.IgnoreCase)

Then inside an assign use this

regexObj.Match(yourString).Groups(1).Value
1 Like
3

Thanks for immediate response @sarathi125 . am getting error as in image.
should i need to close them in double Quotes.

regex1
regex11258×351 21.6 KB

4

Do it in the variable section as shown below,

regex
regex957×58 6.51 KB

5

@sarathi125 – Thanks for your time.

Have uploaded my workflow - can you please verify it because am not getting any output.regex.xaml (5.9 KB)

Below are things am trying to perform

  1. Read one txt file and storing it on one variable
  2. using assign activity getting the values matches
  3. Displaying it using write line.

not able to upload my text file here - excuse me

6

Hi
lets take you have the input stored in a variable name str_input
so in the assign activity mention like this
out_matches = System.Text.RegularExpressions.Regex.Matches(sr_input,“your regex expression”)

where out_matches is a variable of type
System.Collections.Generic.Ienumerable(system.text.RegularExpressions.Regex.Match)

then we can pass this out_matches variable as input to a FOR EACH activity and inside that loop use a writeline activity and mention like item.ToString which will print all the values one by one

Cheers @Fresher

7

Hi

I attached the Workflow with Same input file which attached in the Question

regex
regex831×671 24.6 KB

Important Points to remember :
1.In Matches Activity Property Panel: Ensure the RegexOption= Multiline is selected
image

2.In For Each Activity property Panel:Change TypeArgument to system.text.RegularExpressions.Match

image
image1649×523 24 KB

PFA,
testing.zip (13.4 KB)

8

Hi @Fresher,

Please go to Package Manager first. Then go to All Packages and type System.Regex. After finding it Install it.

Now go to Design pane and find Imports and type System.Regex. Now Double Click on it. Now you are all set.

If found any issue close the .xmal file or the close the Studio. Now Reopen it.

Hope you will be able to use Regex in your workflow.

Thanks & Regards,
Apurba

9

Hi @VISHNU07.

Thanks for the workflow file - but regex pattern which you have used will not suit all the criteria. I need to use below pattern.

Blockquote (?<=Table STH-1\nNATIONAL STUDENT HOUSING MARKET)(.\n)+(.)(?=NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*)

can you please try with this - i tried with this but still not able to generate the output, however in test regex builder the data are getting captured.not sure where am missing.

regex2
regex2951×747 22.3 KB

10

Thanks for the package details :slight_smile: @apurba2samanta

11

Most welcome @Fresher :slightly_smiling_face:

Thanks & Regards,
Apurba

12

Hello @Palaniyappan

Thanks for your time - i don’t find System.Collections.Generic.Ienumerable(system.text.RegularExpressions.Regex.Match) variable type - can you please confirm on it

I found below variable type is used for getting the output of ‘Matches’ :
System.Collections.Generic.IEnumerable<System.Text.RegularExpressions.Match>

Please assist - Thanks

regex3
regex31008×592 25 KB
regex4
regex4985×579 16.3 KB

13

Sure send the input text file
I will check and update

14

@VISHNU07

Please consider the same input text file.

Starting condition should be a combination of below :
Table STH-1
NATIONAL STUDENT HOUSING MARKET

Ending condition should be as below
NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*

eg:

xys
sdfgasg
sdasggasga asdfsd asgfas
Table STH-1
NATIONAL STUDENT HOUSING MARKET
…
…
…
…
…
…
… … …
NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*
fasdfasd
asdfasdfasdf

Note: I need the data present between the bold lines.

15

@VISHNU07
Below pattern working fine in Regex Builder -not sure why its not working while running workflow.

regex5
regex5952×592 23.5 KB

16

Hi @Fresher,

If you want to extract all the data between the keywords Table STH-1
NATIONAL STUDENT HOUSING MARKET and NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*, you can try the below -

Regex.Match(Your_Variable,"(?<=NATIONAL\sSTUDENT\sHOUSING\sMARKET\s\n)[\w+\d+\s\n*.,/&@()-–%$#*“”]+(?=NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*)").Value**

Thanks & Regards,
Apurba

17

Hi @Fresher

Try the attached workflowExtracttextusingregex.xaml (6.2 KB)
Do tell if its working :slight_smile:

18

Hi @apurba2samanta,

am fine with Regex Pattern, as highlighted in above post, is working fine in regex builder (Test text) - but in workflow am not getting any output

19

Hi @Fresher,

Fine. Can you please share your workflow consist of this Regex pattern?

Thanks & Regards,
Apurba

20

Hello @apurba2samanta
Please find the attached workflow

With below pattern am getting the match count as 1 , in regex builer ( test text) - values are getting highlighted and getting the output.

Blockquote(?sim)Market(.*)National.

With this below pattern am getting the match count as 0 , but in regex builer ( test text - Vaues are getting highlighted and not getting any output.

Blockquote (?<=Table STH-1\nNATIONAL STUDENT HOUSING MARKET)(.\n)+(.)(?=NATIONAL STUDENT HOUSING MARKET – SELECT SURVEY RESPONSES*)

regex.xaml (7.7 KB)