Split the text

[Demo_User]

I need to get the last number in each line.Text is extracted from PDf

Name batch order number amount page

Hiyu-4566 a3456 1 1 1,6789 1

Hiyu-5664 a3456 1 1 1,6789 7

Hiyu-5262 a3456 1 1 1,6789 8

Hiyu-6362 a3456 1 1 1,6789 15

Hiyu-6373 a3456 1 1 1,6789 23your tran started

So now from the above will be in string fromat I need to take the page number 1,7,8,15 until your trans started…This all will be in text format

[ppr (Peter)]

Regex can help:

\b\d+(?=$|your tran started|\z)

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[Demo_User]

How to use regix in UiPath

[ppr (Peter)]

we added the CheatSheet for this

e.g. Single Match

strValue = System.Text.RegularExpressions.Regex.Match(YourStringVar, YourPatternString).Value

Or

https://docs.uipath.com/activities/other/latest/user-guide/matches

[Gokul001 (Gokul Balaji)]

Hi @Demo_User

How about this Regular Expression

System.Text.RegularExpressions.Regex.Match(YourString,"\b\d+$|\d+(?=your tran started)").Tostring

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

Hello @Demo_User ,
Try this

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\s)\d+$|(?<=\s)\d+(?=your tran)").Tostring.Trim

[Demo_User]

When I use this am getting only the last digit …I want other page number as well

[Demo_User]

I want 1,7,8,15,23 as output not only 23

[Gokul_Jayakumar (Gokul Jai)]

Try this

string.join(",",System.Text.RegularExpressions.Regex.Matches(YourString,"(?<=\s)\d+$|(?<=\s)\d+(?=your tran)"))

[ppr (Peter)]

@Demo_User

as output not only 23

@ppr

e.g. Single Match

for all matches, we would use Regex.Matches method and then grabbing all values

• by looping over the return result

or

• using a LINQ for grabbing all values

[Demo_User]

Still returns single value

[Gokul_Jayakumar (Gokul Jai)]

Try this

string.join(",",System.Text.RegularExpressions.Regex.Matches(YourString,"(?<=\s)\d+$|(?<=\s)\d+(?=\n|your tran)"))

[Dibyaprakash.Pradhan.042 (Dibyaprakash Pradhan)]

Hi @Demo_User,

Try the following expression in UiPath assign activity with a variable of MatchCollection type.
System.Text.RegularExpressions.Regex.Matches(YoutText,“\d+(?=\n|your tran started)”)

Thanks,
Dibyaprakash

[Demo_User]

Could please keep the string in text file and pass it as string then test it…It is not working for me

[Demo_User]

For me am getting the output 23, below i have document page number 1 of 14
Am getting 23,14 as output not the pervious values

[Demo_User]

About attached is the input file
Am getting 23,14 as output

[Demo_User]

Above is the input I have passed
Getting output 23,14
I need 8,15,23 as output

[Gokul_Jayakumar (Gokul Jai)]

@Demo_User , If possible share the test document here,

[Demo_User]

Sorry its inside the another machine I cant able to share it

[Gokul_Jayakumar (Gokul Jai)]

@Demo_User
Try This

string.join(",",System.Text.RegularExpressions.Regex.Matches(YourString,"\b\d+(?=Your trans|\s\n)"))