FormatNumber

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

Note: 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 – let us know how we can improve!

Leave your feedback here