Regex pattern extracting number

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

give a try on:
grafik
and refer to group. Kindly note also the ignored group (?:…)

(?<=Balance Forward)(?:.*?)([\d,.]{2,})

Thanks a ton!!! especially for all of the explanations you provided with the answer as always!!

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