Help with another regex pattern

[MasterOfLogic (David Oku)]

Hello,

Please can anyone help me with a regex pattern that would get the number/string after the last underscore of this string

spool_0065075582_20JUN2020_12568_2

i.e *****_2 , i am trying to get “2”

Regards

[Steven_McKeering]

@MasterOfLogic

spool_0065075582_20JUN2020_12568_2

Hello

Try this Regex pattern:
.(?=$)

It will return 1 character at the end. As long as the last character is what you want then this will work fine.

[MasterOfLogic (David Oku)]

@Steven_McKeering

.(?=$)

Hello Steve,

Thanks a lot … its working but it doesn’t pick 2 or more digits.
i.e if the string ends with *****_29 it only picks 9 and if it ends with *****_boy it only pick “y”
Find attached

[Pratik_Wavhal]

Hi @MasterOfLogic

You can achieve this by doing String Manipulation also :-

Below thread will give you the output you require :-

Message Box not showing the correct value for the variable during run time

Hi @jeyaprakasamm Below are the steps and workflow which will give the expected accNo as output always even you Debug or Run the workflow Note :- If the account no is going to be last always then only Workflow :- MainPratik.xaml (8.9 KB) String str = “http://xxxx/yyyy/Account/12345” Integer diff = str.Length-str.Replace(“/”,“”).Length String AccountNo = str.Split("/"c)(diff) Output :- [image] Mark as solution and like it Happy Automation Best Regards Er…

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

[Steven_McKeering]

Try this pattern:
\d+(?=$)|[a-zA-Z]+(?=$)

[Pratik_Wavhal]

Hi @MasterOfLogic

If you want regex only then below regex will help you :-

regex101: build, test, and debug regex

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal