Skip to main content Skip to complementary content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

FormatNumber

Creates a string from a numeric value as specified by a pattern.

Information noteNote: This feature is available only if you have installed the R2022-11 Talend Studio monthly update or a later one delivered by Talend. For more information, check with your administrator.

This function returns a String.

Arguments

Value Specify the value to format.

Properties

Pattern Enter the pattern to be used. The following characters are supported:
  • 0: any digit
  • #: any digit, excluding zeroes that can be omitted
  • .: decimal separator
  • -: minus sign
  • ,: grouping separator
  • ;: separates positive and negative sub-patterns
  • %: multiplies the value by 100 and adds % to the string
  • ‰: multiplies the value by 1000 and adds ‰ to the string
  • ¤: currency sign

This property is also available as an argument. If you specify both, the argument value is used and the property value is ignored.

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 – please let us know!

Leave your feedback here