How to separate numbers, decimal numbers and text

My table has a Cost-and-currency, where users can add values. Example - Cost-and-currency 12.34 USD  15 EUR 100 INR    So I need to separate those numbers, decimal numbers and text into separa...