Regex to extract amount after this patter "Code + 3 digit number + Distribution and then get amount , sample Code: 210 -Test 1 - Distribution 2,735.84 , output is : 2,735.84.
If Code + 3 digit number + Distribution but no amount on the last part then dont extract it.
Code: 210 - Test 1 - Distribution
999745 Check 2- Test 2/10/2021 4,000.00
856040 Check1- Test Deposit 2/10/2021 3,700.00
851075 Vis 2/10/2021 651.29
952490 Vis 2/10/2021 651.29
951195 Vis 2/10/2021 651.29
952230 Vis 2/10/2021 6521.29
Code: 210 -Testadas 1 - Distribution 2,735.84
Code: 230 - Testsd 2 - Distribution
853955 Clearing 8/1/2021 47.50
Code: 230 - Test 2 - Distribution 77.50
@AhmedKutraphali - will it be always after the distribution?? Also it would be great if you show us what progress you have made so far (I am asking since you have posted similar regex questions before )