Variable Formatting

Variables that require formatting can be formatted using the variable functions.

Note: At RUNTIME if PAS attempts to write out a file or create a directory it checks to make sure it does not contain any invalid characters (i.e. |?:* etc...). If it does, all invalid characters will be replaced with an underscore "_"

How to Apply formatting

By default variables will be resolved using the default formatting that is defined when creating the variable. However, additional formatting can be applied later in the flow by using the Format variable function.

Place the cursor in any text field at the location you wish to apply formatting
- Note: You can also highlight entire text to replace on insert as well
Click on the ƒ(x) button next to the field to launch the variable / function insert tool
On the second "Functions" tab use the search and select the Format function for the variable type being formatted and click Insert
The preformated function will be inserted into the field.
Then replace the template $[myVar] text with the variable you wish to be formatted.

Examples

Below are some formatting examples for each data type:

Number

A string representing the formatted number

Examples

$[format($[myVar], "0.00")]
$[format($[myVar], "#.##")]
$[format(01234.678, "$###,###.##")]

Outputs

0.60
.6
$1,234.67

Boolean

A portion of the string argument, depending on if the boolean argument is true or false

Examples

$[format($[myVar], "Accepted/Rejected")]
$[format($[myVar], "$[myVar2]/$[myVar3]")]
$[format($[myVar], "$[myVar2]")]

Outputs

True = "Accepted" / False = "Rejected"
True = "myVar2" / False = "myVar3"
True = "myVar"

Date

A string representing the formatted date

Examples

$[format($[myVar], "MM-dd-yy")]
$[format($[myVar], "MMM, yyyy")]
$[format(now(), "hh:mm aa")]

Outputs

08-29-21
Aug, 2021
01:22 PM

Formatting Options

Numbers

0 = digit placeholder (000 = 001)

# = digit no placeholder (### = 1)

. = decimal separator (#.# = 0.5)

, = grouping separator (#,### = 1,000)

Dates

yy = two-digit year

yyyy = four-digit year

m = month (1-12)

mm = two-digit month (01-12)

mmm = three letter month abbreviation (01=Jan)

mmmm = full month name (01=January)

d = day of month (1-31)

dd = two-digit day of month (01 - 31)

H = hours (1-23)

HH = two digit hour (00 - 23) (AM/PM NOT allowed)

M = minutes (0-59)

MM = two digit minute (00 - 59)

s = seconds (0-59)

ss = two digit second (00 - 59)

h = hour (0 - 12 | 12-hour AM/PM format)

hh = two digit hour (00 - 12 | 12-hour AM/PM format)

tt = AM/PM based on the time

zz = time zone (Pacific Daylight Time = PDT)

zzzz = time zone (Pacific Daylight Time)