Formatting Your Data

This section guides you to format your data .For example, you want to display your text in uppercase or lowercase and much more. Here formatting doesn't mean styling your content (font, size, color).

Here is a list of available modifiers. These modifiers are added along with the tokens(merge field).

Modifier

Description

Example

Uppercase

Convert all characters to uppercase

{{upper company_name}}

Lowercase

Convert all characters to lowercase

{{lower client.name}}

Capitalize

Capitalize the first letter

{{capitalize client_name}}

Format Date/Time

Convert date and time to a specific format

{{format_date _date 'DD-MM-YY'}}

Format Number

Change the format of a number (thousands and decimals)

{{format_number number "." "," "3"}}

Abbreviation

Convert text to abbreviation (First letter of each word in caps)

{{abbreviate name "."}}

Format Date/Time

Syntax - {{format_date token_name "format" "language" "add/subtract time"}}

The default language is English(United States).

Example

Input

Output

{{format_date _date 'DD-MM-YY'}}

2019-05-25

25-05-19

{{format_date _date "MMMM DD YYYY" "fr"}}

2019-05-25

mai 25 2019

{{format_date _date "MMMM DD YYYY" "en" "+1years"}}

2019-08-20

August 20 2020

Example

Output

DD-MM-YY

21-11-18

ddd MMM DD HH:mm:ss

Wed Nov 21 14:08:25

MMMM DD YYYY HH:mm:ss

November 21 2018 14:08:25

MMMM DD YYYY

November 21 2018

MMM DD YYYY

Nov 21 2018

YYYY-MM-DD

2018-11-21

MM-DD-YYYY

01-22-2006

MM/DD/YYYY

01/22/2006

MM/DD/YY

01/22/06

DD-MM-YYYY

22-01-2006

DD/MM/YYYY

22/01/2006

DD/MM/YY

22/01/06

X

1542758400

Date/Time Custom Value Table

Token

Output

Year

YYYY

2000, 2001, 2002 ... 2012, 2013

YY

00, 01, 02 ... 12, 13

Month

MMMM

January, February, March ...

MMM

Jan, Feb, Mar ...

MM

01, 02, 03 ... 11, 12

M

1, 2, 3 ... 11, 12

Day of Year

DDDD

001, 002, 003 ... 364, 365

DDD

1, 2, 3 ... 364, 365

Day of Month

DD

01, 02, 03 ... 30, 31

D

1, 2, 3 ... 30, 31

Day of Week

dddd

Monday, Tuesday, Wednesday ...

ddd

Mon, Tue, Wed ...

d

1, 2, 3 ... 6, 7

Hour

HH

00, 01, 02 ... 23, 24

H

0, 1, 2 ... 23, 24

hh

01, 02, 03 ... 11, 12

h

1, 2, 3 ... 11, 12

AM / PM

A

AM, PM

a

am, pm

Minute

mm

00, 01, 02 ... 58, 59

m

0, 1, 2 ... 58, 59

Second

ss

00, 01, 02 ... 58, 59

s

0, 1, 2 ... 58, 59

Sub-second

SSS

000, 001, 002 ... 998, 999

SS

00, 01, 02 ... 98, 99

S

0, 1, 2 ... 8, 9

Timestamp

X

1381685817

Language

Language code

Language & Country

en-au

English (Australia)

en-ca

English (Canada)

en-ie

English (Ireland)

en-il

English (Israel)

en-nz

English (New Zealand)

en-gb

English (United Kingdom)

fr

French

fr-ca

French (Canada)

fr-ch

French (Switzerland)

de

German

de-at

German (Austria)

de-ch

German (Switzerland)

hu

Hungarian

pt

Portuguese

Add/Subtract Time - Manipulate a date and/or time by adding/subtracting time.

To adjust a date/time by a specific amount, you need to supply <+/-> <amount as a number> <unit>. Unit can be "years", "months", "weeks", "days", "hours", "minutes", or "seconds". Here are some examples:

  • +1hours

  • -3days

  • +5years+2months-3minutes

  • +8h

Example

Input

Output

{{format_date _date "MMMM DD YYYY" "en" "+1years"}}

2019-08-20

August 20 2020

{{format_date _date "MMMM DD, YYYY" "en" "+6months"}}

2019-08-20

February 20, 2020

Format Number

Syntax - {{format_number number1 thousand_sep decimal_sep decimal_places}}

Example

Input

Output

{{format_number number1 "." "," "0"}}

123456

12.345

{{format_number number1 "." "," "3"}}

12345.12345

12.345,123

Abbreviation

Syntax - {{abbreviate name suffix}}, Suffix is not mandatory.

Example

Input

Output

{{abbreviate name}}

John Doe

JD

{{abbreviate name "."}}

John Doe

J.D