How to get sub-string from a string

[Krithi1]

Hi,

I have the following string, how to extract the substring out of it?

InputString::

Action Created.
(Confirmation # = 492854374)

No Further action os needed.

OutputString

492854374

What is the best way to extract that output? It’s always numeric.

[ppr (Peter Preuss)]

@Krithi1

Confirmation # = 492854374

[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…

[Krithi1]

number keeps changing and I want only the number.

[ranjith_udayakumar]

Hi @Krithi1 ,

You can achieve that using the following regex pattern - \(\Confirmation\s*\#\s*\=\s*(.*?)\)

It will extract numbers in the text structure you have provided.

strOutput = System.Text.RegularExpressions.Regex.Match(strInput, "\(\Confirmation\s*\#\s*\=\s*(.*?)\)").Groups(1).Value

Regards,
Ranjith Udayakumar

[ppr (Peter Preuss)]

this regex is looking for digits and so it will handle different digits in different length. Or did you mean something different?

[Pradeep_Shiv]

@Krithi1

Action Created.
(Confirmation # = 492854374)

Hello Kirthi,

If your input string is just that, you can use below regular expression to extract numeric values from the string. find below image for reference.

You can use the same by using Assign Activity

1. Use Assign Activity like this, vConfirmationNumber = System.Text.RegularExpresssion.Regex.Match(InputString,“\d+”).ToString

[Krithi1]

@Pradeep_Shiv
I tried this and it gives only the first char from the entire number.

[ppr (Peter Preuss)]

just share with us the details on what was modelled. Feel free to do the prototyping directly within the immediate panel:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[Pradeep_Shiv]

Can you share the screenshot of the input and output?

[Krithi1]

@Pradeep_Shiv

Please ignore my earlier comment. It’s working. It’s just that I did something wrong on my end.