How to get the Required String Using Regex

Help Studio
1

Hi All ,\

Please find the below String:

2

Hey @chandolusathi.kumar,

Welcome to UiPath community!

\d…{1,3}(,\d{3})*.\d{2}

Please try the above regex.

Thank you!

3

not wokring

4

Hi @chandolusathi.kumar ,

Could you provide us with some more example data to make our pattern for the regex exact match for the value to be extracted ? Do we have a keyword that we can use in the text to pinpoint the location of the value ?

Let us know/provide some more example data for helping further.

5

Hey

give a try with

Regex.Match(strInput, "\d..{1,3}(,\d{3})*\.\d{2}").Value

Regards

6

Hi @chandolusathi.kumar,

Sorry for that! Please check the updated expression.

7

Hi @supermanPunch those are the Amount in the format like mentioned below

09.00 or else 100.00 or else 1,000.00 or else 10,000.00 or else 1,00,000.00 or else 10,00,000.00 or else 1,00,00,000.00

kindly help me to get the value which is starts from Numeric value and end with the .00 or else any kind of number like after (.) any kind of numbers with only two digits

8

i didn’t get it kindly share it again

9

Hi @chandolusathi.kumar ,

Use below regex
[\d,]+\.\d{2}

Regards,
Arivu

11

@chandolusathi.kumar ,

According to the requirement mentioned , you could check with the below regex Expression :

[\d,]+\.\d{2}

If the above doesn’t work, let us know for which example data it does not work and what was the implementation done.

12

Meanwhile can you try with this pattern

To get single value

System.Text.RegularExpressions.Regex.Match(InputString,"[0-9,.]+\.\d{2}").Tostring

Use the above expression in the assign activity

To Get multiple matches and you need to loop through it

System.Text.RegularExpressions.Regex.Matches(InputString,"[0-9,.]+\.\d{2}")

Use this above in for each to loop through the matches

Regards
Sudharsan

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.