Regex for 5 digits from longer string

[camaro123]

Hi,

example of my string

1234 test TEST 1234567

from here I need to get 5 digits. Normally the second number has 5 digits, but it happenes that is has more. Then I would need to get first 5 digits from it.

Can you help me here?

[ppr (Peter Preuss)]

@camaro123

1234 test TEST 1234567

[Parvathy (PS Parvathy)]

Hi @camaro123

Check the below assign syntax:

Input = "1234 test TEST 1234567"

Output = System.Text.RegularExpressions.Regex.Match(Input,"\b\d{5}").Value.Trim()

Hope it helps!!

[Anil_G (Anil Gorthi)]

@camaro123

\d{5} should dot he job

Cheers

[Steven_McKeering]

Hey @camaro123

Take a look here for some more information on Regex

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

[batthula.p949]

Hi @camaro123

Please try using the regex to extract the data.

Regex

\b\d{5}

\b - represent the boundary of the text
\d - represent the number format in regex
\d{5} - represent the 5 number to get conjugative
\b\d{5} - represent get only the boundary of the 5 digit number.

UiPath Code using Assign Activity:

number = System.Text.RegularExpressions.Regex.Match(myinput,"\b\d{5}").Value.Trim()

Thanks,
Purushotham