Hello, I have the below strings in which I need to extract the amount part, the regex I have now is “(?<=Balance Forward).+(?<=\s)(.+)”, which extracts the number after the first white space and everything follows it. How this should be modified so
that only the first number part be returned. Thank you so much.
result should be for each of these: 0.00, 0.00, 0.00, 42,818.13, 0.00, 341.52, 0.00, 0.00, 0.00, 53.14
Balance Forward A/P $0.00
Balance Forward $0.00
Balance Forward /VP 0.00
Balance Forward $42,818.13
Balance Forward , $0.00 . 1’11 $3 - 5?: '35
Balance Forward $341.52 :1 a 4 § g a? e“ :75: 3g ’3 3f;
Balance Forward $0.00 2 do 41
Balance Forward , $0.00 . 1’11 $3 - 5?: '35
Balance Forward 0.00
Balance Forward 53.14