Extraction of Number from String in the web browser

[SH_94 (Jacob SH)]

Dear Community,

May i know how can i extract the following number from string (obtained from web browser)?
Data

1. Attachment 12
2. Record23

Result wanted

1. 12
   2.23

I saw there are some post in Uipath regarding this topic but i not really sure what tools and what formula we can use. Is it that we must use for each tool at the end of the workflow in this case?

Appreciate if you can briefly explain on what are the tools and formula can use in this case.

Thank you.

[Palaniyappan (Palaniyappan P)]

Hi

We can try with Regex on this
System.Text.RegularExpressions.Matches(inputstring,“[0-9]+(.[0-9]+)|\d+”)

Once you got the output in a datatable use a FOR EACH ROW activity and pass the above datatable as input

—inside the loop use a assign activity like this
currentrow(“yourcolumnname”) = System.Text.RegularExpressions.Match(Currentrow(“yourcolumnname”).ToString,“[0-9]+(.[0-9]+)”).ToString.Trim

Cheers @SH_94

[ppr (Peter Preuss)]

@SH_94

Data

1. Attachment 12
2. Record23

Result wanted

1. 12
   2.23

We assume the expected output was combined with the numbered list numbers and are not to match

[SH_94 (Jacob SH)]

Hi @Palaniyappan ,

Sorry that maybe the post for result wanted a bit confusing and below is the result that i wanted:

First Data: Attachment 12
Second Data : Record23

First Result wanted : 12
Second Result wanted : 23

Will the previous formula work in this case?

Thank you.

[SH_94 (Jacob SH)]

Hi @ppr ,

May i know what tools u are using ? Can u provide the screenshot ?

Thank you.

[ppr (Peter Preuss)]

for prototyping we are using online tools

Regex Storm - Online Resource for .NET Regular Expressions

regex101: build, test, and debug regex

then we incorporate it in our implementation

Also have a look 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…

[Palaniyappan (Palaniyappan P)]

@SH_94

Will the previous formula work in this case

Ofcourse it will
And it will work for both whole and decimal values

Pls give a try and let know for any clarification

Cheers @SH_94

[SH_94 (Jacob SH)]

Hi @Palaniyappan ,

Noted on this. May i know what we need to do if we didn’t use the for each row tool?Reason being is the data extract is just one sentence from the web browser and it does not contribute the datatable.

If i plan to use assign activity in this case. Could you guide me on this?

Thank you.

[Palaniyappan (Palaniyappan P)]

@Palaniyappan

0-9]+(.[0-9]+)|\d+

Fine if the input is in string variable named in_string

Then use this expression in a assign activity

Str_output = System.Text.RegularExpressions.Regex.Replace(in_string,”[^0-9.]”,””).ToString

Cheers @SH_94

[Palaniyappan (Palaniyappan P)]

is this working @SH_94

[SH_94 (Jacob SH)]

Hi @Palaniyappan ,

It works and many thanks for your clear explanation

[SH_94 (Jacob SH)]

Hi @Palaniyappan ,

May i know how can we convert it to number in this case? Because it seem like it is in string format.
.

Thank you.

[Palaniyappan (Palaniyappan P)]

May I know what is the datatype of output attachment

Try with outputattachment.Count>0
@SH_94

[SH_94 (Jacob SH)]

Hi @Palaniyappan ,

many thanks and i able to solve it.