Regex to extract a number between a dynamic number

Help Studio
,
1

Hi, I’m struggling to extract this:
Example:

Invoice Amount 20,000.00 18,000.00

From the above i want to extract the 20,000.00 using regex but its dynamic, there may be any number of digits and also that 18,000.00 also dynamic we can have any no. of digits. The only static word is Invoice Amount. Please help me. Thanks

2

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Invoice Amount )[\d,]+").Value

Regards,

3

Hi @Yoichi Thanks for your suggestion but its taking only the 20,000 and .00 is not extracted

4

Hi,

Sorry,i had a mistake. How about the following?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Invoice Amount )[\d.,]+").Value
1 Like
5

Hi @padmapadh1895

Try this out

6

Thanks @Yoichi and @Sudharsan_Ka and also here i want to extract the second dynamic number which is 18,000.00 is that possible?

7

Hi,

Can you check the following pattern?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=Invoice Amount [\d.,]+ )[\d.,]+").Value

or it might work if we use Matches activity with the pattern : "[\d.,]+"
It returns multiple matches.

Regards,

2 Likes
8

Thanks @Yoichi it works

1 Like
9

Hi anyone in the below text i want to extract the amount after Total which is 24,104.00 and 2,89,246 but when i try with a sample it matches with another “Total” in the below. can anyone tell how to use regex to extract both the amount after total dynamically.

Total 24,104.00 2,89,246.00
CONTRIBUTIONS
Total 1,800.00 30,754.00
Grand Total (CTC) 3,20,000.0

10

Hi,

Hope the following helps you.

img20210815-2
img20210815-2661×549 13.9 KB 

System.Text.RegularExpressions.Regex.Matches(yourString,"(?<=Total )([\d,.]+)\s*([\d,.]+)")

Sequence1.xaml (6.8 KB)

Regards,

11

Thanks for the suggestion @Yoichi … But here its selecting both the amounts of total (24,104.00 2,89,246.00) but i want to use regex to extract the first number (24,104.00) separately and the second number (2,89,246.00) separately

12

Hi @padmapadh1895

You can try with group in regex

Group 1 will be the first value group 2 will the second value

Regards
Sudharsan

13

Hi,

Can you check output expression of the sample as the following.

img20210816-5
img20210816-5661×549 14 KB 

item.Group(1).Value
item.Group(2).Value

Regards,

1 Like