REgexUipath

Help
, , ,
1

I have string sample as “One time charge 472.23 Monthly bills 789.23
Postpaid 502.36 Prepaid 899.32
Region 452.23 National 60.01”
Required text is 472.23 789.23
502.36 899.32
452.23 60.01

How to write regex for this

Thanks
Vijallaxshmi

2

Hi @vijaylaxmi_teli,

Try this
\d+(\.\d{1,2})?

1 Like
3

No didn’t work in the required way…i have date also like “14-Jan-2019= 483.23”…It is extracting 14 too.

Thanks
Vijaylaxshmi

4

Hi,

Can you try the following?

\d+\.\d{2}

Regards,

1 Like
5

Try this

\d+[.]\d{2}

Thanks
@vijaylaxmi_teli

6

@vijaylaxmi_teli

Try this one
\d+(\.\d{2}+)

7

Use this below regex,
“(?<=\s)(\d+.\d+)”
You will get all the six values separately.

8

Hi @vijaylaxmi_teli

try this

\d+.\d{1,4}+

Thanks
Ashwin S

9

Check this workflow,
TestSequence.xaml (6.2 KB)

1 Like
10

Hi @vijaylaxmi_teli , you got solution or not ?

11

Hi @vijaylaxmi_teli,
Try this Pattern in matches Activity : [0-9]{1,}.[0-9]{1,}

12

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