Merge Field Formatters

Format Numbers

These formatters can be used on Whole Number or Decimal field types.

Note: If you want to format a text field with these formatters you will need to cast the field as a number field first.

Formatter	Description	ESL Example	Output Example
c	Currency with $ and 2dp	[Merge(c)]	$1,500.00
n0	With a comma	[Merge(n0)]	1,500
g	Without a comma	[Merge(g)]	1500
f or fn	Without a comma but with decimal places where n = number of decimal places, default is 2dp	[Merge(f)] [Merge(f4)]	1500.00 1500.0000
dn	Set number of digits n = minumum number of digits (whole number fields only)	[Merge(d6)]	001500
en	Exponential where n = the number of decimal places, default is 6dp	[Merge(e1)]	1.5e+003
p	Percentage with a space in front of the percent sign	[Merge(p)]	10.01 %
0%	Percentage without a space in front of the percent sign	[Merge(0%)]	10.01%

Format Mobile Numbers

These formatters can be used on Mobile Number field types.

Note: If you want to format a text field with these formatters you will need to cast the field as a mobile number field first.

Formatter	Description	ESL Example	Output Example
f	Friendly format with spaces	[Merge(f)]	021 123 456
f0	Friendly format without spaces	[Merge(f0)]	021123456
fz	Friendly format for NZ mobile numbers only, will return null for any non-NZ number	[Merge(fz)]	021 123 456
g	National with country code (e.g. 64), no spaces	[Merge(g)]	6421123456
i	International with + country code (e.g. +64), no spaces	[Merge(i)]	[phone]

Format Dates

These formatters can be used on Date and Date/Time field types.

Note: If you want to format a text field with these formatters you will need to cast the field as a date field first.

You can combine each of these to format your date as required. For example:

[Merge(dddd, d MMMM yyyy)] = Monday, 1 March 2010
[Merge(dd/MM/yy)] = 01/03/10
[Merge(hh:mm:ss tt)] = 09:25:36 am

Formatter	Description	ESL Example	Output Example
dddd	Formats day of week to full text	[Merge(dddd)]	Tuesday
ddd	Formats day of week to short text	[Merge(ddd)]	Tue
dd	Formats day of month to 2 digits	[Merge(dd)]	03
d	Formats day of month to 1 digit	[Merge(d)]	3
MMMM	Formats month to full text	[Merge(MMMM)]	April
MMM	Formats month to short text	[Merge(MMM)]	Apr
MM	Formats month to 2 digits	[Merge(MM)]	04
M	Formats month to 1 digit	[Merge( M)]	4
yyyy	Formats year to 4 digits	[Merge(yyyy)]	2010
yy	Formats year to 2 digits	[Merge(yy)]	10
hh	Include hours	[Merge(hh)]	11
mm	Include minutes	[Merge(mm)]	30
ss	Include seconds	[Merge(ss)]	00
tt	Include am/pm	[Merge(tt)]	am

Format GUIDs

These formatters can be used on GUID field types.

Note: If you want to format a text field with these formatters you will need to cast the field as a Unique Identifier field first.

Formatter	Description	ESL Example	Output Example
b	Braces and dashes	[Merge(b)]	{00000000-0000-0000-0000-000000000000}
d	No braces, with dashes	[Merge(d)]	00000000-0000-0000-0000-000000000000
n	No braces and no dashes	[Merge(n)]	00000000000000000000000000000000
p	Parentheses rather than braces, with dashes	[Merge(p)]	(00000000-0000-0000-0000-000000000000)