Skip to main content Skip to complementary content


Creates a string with the input numeric value formatted with a specific pattern.

Information noteNote: This feature is only available in Talend Data Mapper.


  1. Numeric value.
  2. String pattern. The pattern should follow the Java DecimalFormat pattern. For more information, see theOracle documentation.


Expression Result
formatNumber(12332.123456, "EUR,###.-") "EUR 12,332.-"

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!