Converting the amount field in string to double

[phajiyev]

I have a field which shows the amount as String in following format "3,000,000.00 USD" and I want to convert it to double to show it as 3000000.00 without a currency and store it in a double format. Is there any formula I can use to make this conversion without using multiple Alteryx tools?  

[atcodedog05 · Accepted solution]

Hi @phajiyev 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs · Accepted solution]

@phajiyev another method using Regex replace