LOCAL_S

Syntax

Example

Description/Remarks

LOCAL_S "numeric_text", "decimal_separator", "group_separator"

LOCAL_S "1,234.567", ".", ","

If the regional options are set to "Italian (Italy)", this formula returns the string "1234,567".

This command converts any numeric string to the format of the data entry workstation's regional options.  It returns the regionally formatted value as both a string value and a numeric value.

In most cases, any number that the template displays to the end user, outputs to a file or device, etc., will automatically be formatted according to the data entry workstation's regional options.  However, in the rare case where the value is not automatically formatted according to the data entry workstation's regional options, you can use the LOCAL_S command to format the value correctly.

Parameters for the LOCAL_S command are as follows:

  • "numeric_text" must be a string that contains a number.  For instructions on converting numeric values to strings, see CSTR.

  • "decimal_separator" must be the character that separates whole numbers from tenths, hundredths, thousandths, etc., in the "numeric_text".

  • "group_separator" must be the character that separates thousands, millions, billions, etc., in the "numeric_text".

For more information, see Templates and regional options.