Split price and currency from one cell

Task

One table column contains price and currency together, for example 1 250,50 EUR or 99.90 USD. The result needs separate price and currency columns.

Short answer

For price, keep the number, remove thousand spaces, and replace the decimal comma with a dot. For currency, keep only the symbol or currency code.

How to Do It in Eofferix

Open the settings of the price column.
The animation shows the click on the settings icon of the price column.
Add a regex rule for price: [0-9]+(?:\s[0-9]{3})*(?:[,.][0-9]+)?. It keeps only the numeric part.
The regex keeps the number and removes the currency text.
If the price contains thousand spaces, add a rule that removes spaces.
After this step, 1 250,50 becomes 1250,50.
Add a rule that replaces comma with dot: search for , and put . in the result field.
The result field contains only a dot, so the decimal part becomes 1250.50.
Create or open the currency column and add a regex rule: \b(?:USD|EUR|GBP)\b|€|\$.
The second result column receives only the currency.