AppCtrlScript

AppCtrlScript	MAY Computer
Help

FORMAT

Applies to
AppCtrlScript (Module: wmACScr1.dll)

Group
String

See also
FORMATDATE, FORMATTIME, FORMATTIMESTAMP

Reformat a given string and store the result in the specified script variable. If you want to reformat a string that contains a date value then you probably will be better to use FORMATDATE and FORMATTIME because these commands interpret the source string as date and time value respectively.

Syntax

FORMAT <VariableName>, <Source>, <Format>

Part

Description

<VariableName> Name of the script variable where to store the result.

<Source> Source string.

<Format>
Format string:
0 ... Digit or zero
# ... Digit or nothing
. ... Decimal placeholder (local setting)
, ... Thousands separator (local setting)
: ... Time separator (local setting)
/ ... Date separator (local setting)
% ... Multiply value with 100 and append "%" character
@ ... Character or space
& ... Character or nothing
< ... Force lower case
> ... Force upper case
! ... Force left to right fill of placeholders

Further date and time formatting see here.

Applies to	AppCtrlScript (Module: wmACScr1.dll)
Group	String
See also	FORMATDATE, FORMATTIME, FORMATTIMESTAMP

Part	Description
<VariableName>	Name of the script variable where to store the result.
<Source>	Source string.
<Format>	Format string: 0 ... Digit or zero # ... Digit or nothing . ... Decimal placeholder (local setting) , ... Thousands separator (local setting) : ... Time separator (local setting) / ... Date separator (local setting) % ... Multiply value with 100 and append "%" character @ ... Character or space & ... Character or nothing < ... Force lower case > ... Force upper case ! ... Force left to right fill of placeholders Further date and time formatting see here.