Text Component

Fnd_Text_FormatNumber

Fnd_Text_FormatNumber (string, format) -> Text

Legacy manual page 237

Parameters

ParameterTypeDescription
stringTextNumeric string to format as text
formatTextFormat to use
Function resultTextFormatted number as text

Description

This function returns formatted string of the numeric string removing any dashes, "E"s, and periods.

$formattednumber_t:=Fnd_Text_FormatNumber ("123.45", "$###.##")
Extracted source text
            Fnd_Text_FormatNumber (string, format) ➜ Text

              Parameter                Type               Description
              string                   Text               Numeric string to format as text
              format                   Text               Format to use
              Function result          Text               Formatted number as text

            This function returns formatted string of the numeric string removing any dashes, "E"s, and periods.
              $formattednumber_t:=Fnd_Text_FormatNumber ("123.45", "$###.##")