How to get the specific number from the text

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

Hi Team,

I need to extract the specific text from a string.

Example - “Putta sri sai rishik
{1:gerwbvhcnijxofb}
:20:SBI1234567890
:79:09876543
AMOUNT:9999
Value:0909”

Result - SBI1234567890

Here :20: is the only common anchor but after that we are not sure how much length number will come !!

Thanks

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

CC @lrtetala

Help Me if you were available !!

[vrdabberu (Varunraj Dabberu)]

Hi @Putta_Sri_Sai_Rishik_Chow

Input="Putta sri sai rishik
{1:gerwbvhcnijxofb}
:20:SBI1234567890
:79:09876543
AMOUNT:9999
Value:0909"

Output= System.Text.RegularExpressions.Regex.Match(Input,"(?<=20\:)[A-Z]*\d*").Value

Regards

[pravallikapaluri]

Hi @Putta_Sri_Sai_Rishik_Chow

System.Text.RegularExpressions.Regex.Match(yourInputString, "(?<=:20:)[^\r\n]+").Value

[mkankatala (Mahesh Kankatala)]

Hi @Putta_Sri_Sai_Rishik_Chow

You can use the below regular expression to get the value after :20:

System.Text.RegularExpressions.Regex.Match(yourInputString, "(?<=:20:).*").Value

The above expression will take after the values of :20:

Hope it helps!!

[Putta_Sri_Sai_Rishik_Chow (Putta Sri Sai Rishik Chowdary)]

hI @vrdabberu @pravallikapaluri

As im very new to regex…Thanks for ur help

Sometimes we are getting the scenarios with combination of symbols like “-”, “.” ,“/” (attached text below)

thriesh oouhunbgbPAY
{1:,KJHJDGFXCVIUTG8765R}{2:POIFUHCVBN9087546R}
:20:UYHHG-865445

thriesh oouhunbgbPAY
{1:,KJHJDGFXCVIUTG8765R}{2:POIFUHCVBN9087546R}
:20:UYHHG/8654.45

Thanks

[mkankatala (Mahesh Kankatala)]

@Putta_Sri_Sai_Rishik_Chow you can try this

System.Text.RegularExpressions.Regex.Match(yourInputString, "(?<=:20:).*").Value

[pravallikapaluri]

@Putta_Sri_Sai_Rishik_Chow

[vrdabberu (Varunraj Dabberu)]

Hi @Putta_Sri_Sai_Rishik_Chow

Try the above regex. This will work all the above scenarios

Output= System.Text.RegularExpressions.Regex.Match(Input,"(?<=20\:)[A-Z].*\d*").Value

Regards

[lrtetala (Lakshman Reddy)]

Hello @Putta_Sri_Sai_Rishik_Chow

Cheers!!

[Steven_McKeering]

Hello

@Putta_Sri_Sai_Rishik_Chow

As im very new to regex

You can learn more about regex here:

Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

THE PURPOSE OF THIS POST IS TO HELP NEW REGEX USERS If you need help with Regex be sure to provide in your post, a Sample, the Output and the Pattern (as much as you know). CONTENTS: Section : I need a Regex Pattern ASAP! - My first Regex Post Section : Regex samples that you can use! Section : I need help applying regex in UiPath Section : Regex Matches and Groups Section : Le…

Cheers

Steve

[sasi_poosarla (sasi p)]

@Putta_Sri_Sai_Rishik_Chow

System.Text.RegularExpressions.Regex.Match(str,“(?<=20:).*”).Value

Cheers!!