Skip to main content
Converts a value into a float (1.00, 2.05, 10.50, etc). Use this when a decimal number arrives as text, such as a price of "19.99" from a CSV file or an API, and the target system needs a real number it can calculate with rather than a piece of text. It reads the number from the start of the value and keeps the decimal part, so "19.99" becomes 19.99 and "10.50 EUR" becomes 10.5. A value that does not start with a number becomes 0.

Fields

This mapper has no settings to configure. Point it at the value you want to convert and it does the rest.

Sample data

Input:
Output: