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 |
Solved! Go to Solution.
Hi @Faye_Karas ,
This RegEx should work.
(.*?) ([\d,\.]*) (\$[\d,\.]*)
You may want to try your expressions on https://regex101.com/
Good luck.
worked perfectly! Thank you!