Regex to extract amount in a multi line data

Help Activities
, ,
1

I wanted to extract every amount after 8 Ending Inventory (5+6+7) . for example on the text file below the output are 0.00 and 2,270,059.60 . It should get all the amount on multi lines after 8 Ending Inventory (5+6+7) . Thanks for any idea .

The data is in the text file
datatext.txt (873 Bytes)

2

Hi,

Can you try the following pattern?

"(?<=8 Ending nventory \(5\+6\+7\)\s*)[.,\d]+"

Sample20210301-2.zip (2.7 KB)

Regards,

1 Like
3

@AhmedKutraphali
maybe we can bind it on the 9 as an achor:

grafik
grafik918×736 38 KB

1 Like
4

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