Pulling 2 pieces from the text variable and creating 2 variables separately?

[Mirisage]

Hi Forum,
I have an Excel dataset with one variable called "Text" with several hudred observations.

Obs Text
1 As on June 20, 2017 balance was $50,277.58 USD (share price is low $106.74)
2 As on August 4, 2017 balance was $52,111 USD (share price is low $108.64)
3 As on Sep 27, 2017 balance was $54,205.80 USD (share price is low $108.92)


Q:
I want to pull the date piece in the above "Text" variable and create a separate variable called "Var_1".
Also I want to pull the USD values pieces and create a separate vaiable called "Var_2".

Please see the attahced Excel file for a clearer view.

So, far I have been extracting the two pieces and creating the two vairalbes manually which is strenous and error prone.

Would appreciate if you could help me to automate the process.
Thanks

Mirisa