Regex to extract the third set of amount or number

@prasath17 but it did not work in this one , as you can see on the screenshot

@AhmedKutraphali - Please provide the proper input …does your text starts with Total Code : or not??

@AhmedKutraphali - Check this…I have adjusted the pattern. Previous pattern did not work, because 14-000 etc has only 18 characters…thats why…

Yes , try this one @prasath17

Total Code : 516-000-3417-000-00  174.26  0.00  174.26

Total Code : 421-000-31220-000-00  901,358.63  1,264,111.83 -362,753.20


21983 Purchase Order  1.00  840.96 -840.96
Total for Supplier : 78225020 - South-East Lumber Co  0.020  8340.96 -8340.96

20978 Purchase Order  0.00  1,2533.60 -1,263.60
Total for Supplier : 790230T10 - Flooring  0.00  1,263.60 -1,263.60

Total Code : 421-000-3110-000-01  901,358.63  1,264,111.83 111,743.20
Total Code : Handling Fee 435.00 0.00 435.00

@AhmedKutraphali - Check this…You have multiple spaces before 174 so changed \s? to \s+

Updated:

1 Like

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