Split Currencies
Infoveave Data Automation — Text & String
A salary column that reads 75000 USD becomes two columns — 85000 as a number and USD as text — so you can aggregate totals, filter by currency, and convert values all without touching the raw string.
Financial data from ERPs, HRIS platforms, and procurement tools often stores monetary values with their currency code in a single text column — a format designed for readability that breaks quantitative analysis. Aggregating totals, filtering by currency region, or applying exchange rate conversion are all impossible until the amount and the currency are separated into their own columns. Split Currencies handles the decomposition automatically regardless of whether the currency code appears before or after the amount and regardless of the separator style — no regex, no parsing logic, no manual column cleaning needed.
What Split Currencies does
Split combined monetary value strings like 75000 USD or 85000 Rs into separate Amount and Currency columns in Infoveave. Enable numeric aggregation, currency filtering, and multi-currency financial reporting from raw monetary data columns.
Part of Infoveave Data Automation on the Unified Data Platform.
When to use Split Currencies
- You have a salary, price, cost, or revenue column that combines the numeric amount and currency code or symbol into a single string like 75000 USD, 850.50 EUR, or 85000 Rs and you need to perform numeric aggregation or currency-based filtering
- You are preparing multi-currency financial data for reporting or currency conversion and need the amount as a numeric column and the currency as a separate text column before applying exchange rate logic
- You are loading data from an ERP, HRIS, or procurement system that exports monetary fields as combined strings rather than separate amount and currency fields
- You need to group, filter, or aggregate financial records by currency — for example summing salaries per currency region — which requires currency to be a separate filterable column
When to avoid it
- Your monetary values are already stored as numeric amounts in a proper numeric column — no splitting is needed, and applying this transformation to a clean numeric column may produce unexpected results
- Your column mixes monetary values with other types of content beyond a simple amount-currency pair — apply Find and Replace or Find Text first to isolate and standardize the monetary strings
- You need to convert amounts from one currency to another — Split Currencies handles the structural separation only; currency conversion requires a separate calculation step using exchange rate data after the split
Where it fits in your Infoveave automation
Split Currencies is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Split Currencies
Real scenarios where this transformation saves hours of manual work.
Normalize Multi-Currency Salary Data from HRIS Exports
A finance team processes global headcount data exported from an HRIS system where the salary field combines the numeric value and the ISO currency code in a single text field — 75000 USD, 6500000 JPY, 85000 INR. Split Currencies separates each record into an Amount column and a Currency column. The team can then sum salaries per currency region, apply exchange rate tables using the Currency column as the join key, and produce consolidated global payroll figures in a base currency.
Prepare Multi-Currency Product Pricing Data for Analysis
A retail data team processes a product catalog exported from a pricing tool where each product's price is stored as a combined string — 29.99 USD, 24.99 GBP, 34.99 EUR. Split Currencies extracts the numeric price into an Amount column and the currency code into a Currency column. The team can then filter pricing by currency, calculate average prices per region, identify pricing outliers within each currency, and feed the structured data into a localization reporting dashboard.
Separate Component Costs and Currencies from Procurement Exports
A procurement team processes supplier component cost data where each cost record includes the purchase price combined with the supplier's invoicing currency in a single text field — 1200 EUR, 85000 INR, 950 GBP. Split Currencies creates separate Amount and Currency columns enabling the team to sum component costs per supplier region, compare costs in local currency terms, and apply exchange rate normalization before rolling up total procurement costs in the base reporting currency.
See Split Currencies in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
SalaryYesInput Data
| Employee ID | Name | Salary |
|---|---|---|
| E001 | John Doe | 75000 USD |
| E002 | Marie Dupont | 85000 Rs |
| E003 | Carlos Gomez | 72000 $ |
Output Data
| Employee ID | Name | Salary | Salary_Amount | Salary_Currency |
|---|---|---|---|---|
| E001 | John Doe | 75000 USD | 75000 | USD |
| E002 | Marie Dupont | 85000 Rs | 85000 | Rs |
| E003 | Carlos Gomez | 72000 $ | 72000 | $ |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column Name
Select the column containing combined monetary strings. The column should have values where a numeric amount and a currency code or symbol are stored together in a single text field. The format can vary across rows — the amount may precede or follow the currency, and any whitespace between them is handled automatically. The output columns are named by appending _Amount and _Currency to the original column name.
Include Original
Choose whether to retain the original combined monetary string column alongside the new Amount and Currency columns. Keep the original if you need the full string for display purposes, debugging, or audit comparisons. Disable it to simplify the output when the original combined column is no longer needed after the split.
Frequently asked questions
Everything you need to know about Split Currencies in Infoveave.
Also in Text & String — and what runs before & after
Transformations in the same family as Split Currencies, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Split Currencies is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?