How to parse words from numbers using regex

[Faye_Karas]

How can I use Regex to parse words from numbers using regex.  Below is a sample data set

CHECKS ISSUED 22,801 $20,083,825.49

MANUAL DELETE RETURN MAIL (DRM) 58 $48,329.66

Expected output :

CHECKS ISSUED	22,901	$20,000,825.59
MANUAL DELETE RETURN MAIL (DRM)	59	$48,929.66

[Yoshiro_Fujimori · Accepted solution]

Hi @Faye_Karas ,

This RegEx should work.

(.*?) ([\d,\.]*) (\$[\d,\.]*)

You may want to try your expressions on https://regex101.com/

Good luck.

[Faye_Karas]

worked perfectly!  Thank you!