Page History

With a mask it is possible to give a value a formatting. Every mask results in a specific format and is implemented using a mask type.

Info
The listed masks can only be used in documents, e.g.

...

PDF documents.

Category	Name	Description	Example
String	Acronym	Adds a dot (.) behind every character and makes it uppercase	V.A.R.A.
	AllLowercase	All small caps	a value
	AllUppercase

Capitalise

Capitalize all

1

A VALUE


	FirstUppercase	Capitalize first word in sentence, rest in small caps.	A value
Boolean

BankAccountNr_NLDutch bank account number57.15.18.833

	Bool_InWords	Boolean in words	yes
	Bool_InWordsAbbr	Boolean in words abbreviated	y
Currency	Curr_Dollar_ValueInWords	Dollar value in words	Fivehundred dollar and twelve cents
	Curr_Dollar_ValueInWords_ZeroCents	Dollar value in words, zero cents	Fivehundred dollar and zero cents
	Curr_Euro_2Digits_1000Sep	Euro value, two digits with thousand separator	€ 500.000,00
	Curr_Euro_2DigitsNoZeros	Euro value, two non zero digits	€ 500000,-
	Curr_Euro_2DigitsNoZeros_1000Sep	Euro value, two non zero digits with thousand separator	€ 500.000,-
	Curr_Euro_3DigitsNoZeros	Euro value, three non zero digits	€ 500000,-
	Curr_Euro_3DigitsNoZeros_1000Sep	Euro value, three non zero digits with thousand separator	€ 500.000,-
	Curr_Euro_NoDigits	Euro value, no digits	€ 500000
	Curr_Euro_NoDigits_1000Sep	Euro value, no digits with thousand separator	€ 500.000
	Curr_Euro_ValueInWords	Euro value in words	Fivehundred euros and twelve cents
	Curr_Euro_ValueInWords_ZeroCents	Euro value in words, zero cents	Fivehundred euros and zero cents
	Curr_Pound_ValueInWords	Pound value in words	Fivehundred pound and twelve pence
	Curr_Pound_ValueInWords_Zeropennies	Pound value in words, zero pence	Fivehundred pound and twelve pence
Date	Date_day	Day from date in words	negentien
	Date_dayofweek	Week day	donderdag
	Date_dayofweekddmonthyyyy_SpaceSep	weekday day month in words year, in numbers with

zero's

zeros	donderdag 19 maart 2009
	Date_dd	Day from date in numbers	19
	Date_ddMM_MinSep	Day-month in numbers with

zero's

zeros	19-03
	Date_ddMM_SlashSep	Day/month in numbers with

zero's

zeros	19/03
	Date_ddMM_SpaceSep	Day month in numbers with

zero's

zeros	19 03
	Date_ddMMyy_

hhmm_12hours

MinSep

Day

day-month-year

(

short

) hours:minutes, 12-hour clock

, in numbers with zeros

19-03-09

03-12-09 02:32 PM


	Date_ddMMyy_

hhmmss_12hoursDay-month-year(short) hours:minutes:seconds, 12-hour clock

SlashSep

day/month/year short, in numbers with zeros

19/03/09

03-12-09 02:32:55 PM


	Date_ddMMyy_

HHmmss_24hoursDay-month-year(short) hours:minutes:seconds, 24-hour clock03-12-09 14:32:55

SpaceSep	day month year short, in numbers with zeros	19 03 09
	Date_ddMMyyyy

Date_ddMMyy

_MinSep

day-month-year

short

, in numbers with

zero's

zeros

19-03-

09

2009
	Date_ddMMyyyy_NoSep	daymonthyear, in numbers with zeros	19032009
	Date_

ddMMyy

ddMMyyyy_SlashSep

day/month/year

short

, in numbers with

zero's

zeros

19/03/

09

2009
	Date_

ddMMyy

ddMMyyyy_SpaceSep

day month year

short

, in numbers with

zero's

zeros

19 03

09

2009
	Date_

ddMMyyyy

ddmonthyyyy_

hhmm_12hours

MinSep

Day

day-month in words-year

hours:minutes, 12-hour clock

, in numbers with zeros

19-maart-2009

03-12-2009 02:32 PM


	Date_

ddMMyyyy

ddmonthyyyy_

hhmmss_12hoursDay-month-year hours:minutes:seconds, 12-hour clock03-12-2009 02:32:55 PM

SlashSep	day/month in words/year, in numbers with zeros	19/maart/2009
	Date_ddmonthyyyy_SpaceSep	day month in words year, in numbers with zeros	19 maart 2009
	Date_ddshortmonthyyyy

Date_ddMMyyyy_HHmmss_24hoursDay-month-year hours:minutes:seconds, 24-hour clock03-12-2009 14:32:55Date_ddMMyyyy

_MinSep

day-month short-year, in numbers with

zero's

zeros

19-

03

mrt-2009
	Date_

ddMMyyyy

ddshortmonthyyyy_

NoSep

SlashSep

day/month short/year

daymonthyear

, in numbers with

zero's19032009

zeros	19/mrt/2009
	Date_

ddMMyyyy

ddshortmonthyyyy_

SlashSep

SpaceSep

day

/

month

/

short year, in numbers with

zero's

zeros

19

/03/

mrt 2009
	Date_

ddMMyyyy19 03

dmonthyyyy_SpaceSep

short day month in words year, in numbers with

zero's

zeros	1 maart 2009
	Date_MM	Month from date in numbers	03
	Date_month	Month from date in words	maart
	Date_RelativeToToday_InWords	Date relative to today in words	1 year, 2 months and 26 days ago
	Date_shortmonth	Abreviated month from date	mrt
	Date_Year	Year from date in words	tweeduizend negen
	Date_yyyy	Year from date in numbers

2009
	Date_

ddmonthyyyy

yyyyMMdd_MinSep

day

year-month

in words

-

year

day, in numbers with

zero's

zeros

19

2009-

maart

03-

2009

19
	Date_

ddmonthyyyy

yyyyMMdd_

SlashSep

SpaceSep

day/

year month in words

/year

day, in numbers with

zero's

zeros

2009 03 19

/maart/2009


	Date_

ddmonthyyyy

yyyymonthdd_

SpaceSep

MinSep	month day year, in numbers with zeros, month in words	2009-maart-19
	Date_yyyymonthdd_SpaceSep	year month day, in numbers with

zero's

zeros

2009 maart 19

maart 2009


	Date_

ddshortmonthyyyy

yyyyshortmonthdd_MinSep

day

year-month short-

year

day, in numbers with

zero's

zeros

19

2009-mrt-

2009

19
	Date_

ddshortmonthyyyy

yyyyshortmonthdd_SlashSep

day

year/month short/

year

day, in numbers with

zero's

zeros

19

2009/mrt/

2009

19
	Date_

ddshortmonthyyyy

yyyyshortmonthdd_SpaceSep

day

year month short

year

day, in numbers with

zero's

zeros

19 mrt 2009

2009 mrt 19
	DayOfWeek	Day of the week, starts on Sunday	Wednesday
	DayOfWorkWeek	Day of the workweek, starts on Monday	Thursday
Date & time	Date_ddMMyy_hhmm_12hours	Day-month-year(short) hours:minutes, 12-hour clock	03-12-09 02:32 PM
	Date_ddMMyy_hhmmss_12hours	Day-month-year(short) hours:minutes:seconds, 12-hour clock	03-12-09 02:32:55 PM
	Date_ddMMyy_HHmmss_24hours	Day-month-year(short) hours:minutes:seconds, 24-hour clock	03-12-09 14:32:55
	Date_ddMMyyyy_hhmm_12hours	Day-month-year hours:minutes, 12-hour clock	03-12-2009 02:32 PM
	Date_ddMMyyyy_hhmmss_12hours	Day-month-year hours:minutes:seconds, 12-hour clock	03-12-2009 02:32:55 PM
	Date_ddMMyyyy_HHmmss_24hours	Day-month-year hours:minutes:seconds, 24-hour clock	03-12-2009 14:32:55
	Date_dMMyy_HHmmss_24hours	Day-month-year(short) hours:minutes:seconds, 24-hour clock	3-12-09 14:32:55
	Date_dMMyy_hmm_12hours	Day-month-year(short) hours:minutes, 12-hour clock	3-12-09 2:32 PM
	Date_dMMyy_hmmss_12hours	Day-month-year(short) hours:minutes:seconds, 12-hour clock	3-12-09 2:32:55 PM
	Date_dMMyyyy_HHmmss_24hours	Day-month-year hours:minutes:seconds, 24-hour clock	3-12-2009 14:32:55
	Date_dMMyyyy_hmm_12hours	Day-month-year hours:minutes, 12-hour clock	3-12-2009 2:32 PM
	Date_dMMyyyy_hmmss_12hours	Day-month-year hours:minutes:seconds, 12-hour clock	3-12-2009 2:32:55 PM
	Date_dmonthyyyy_HHmmss_24hours	Day month(long) year hours:minutes, 24-hour clock	3 december 2009 14:32 PM
	Date_dmonthyyyy_hmm_12hours	Day month(long) year hours:minutes, 12-hour clock	3 december 2009 2:32 PM
Time

Date

Time_

dmonthyyyy

hhmm_

SpaceSepshort day month in words year, in numbers with zero's1 maart 2009

12hours	Hours:minutes, 12-hour clock AM/PM, with zero`s	02:32 PM
	Time_HHmm_24hours	Hours:minutes, 24-hour clock	14:32
	Time_hhmmss_12hours	Hours:minutes:seconds, 12-hour clock AM/PM, with zero`s	02:32:55 PM
	Time_HHmmss_24hours	Hours:minutes:seconds, 24-hour clock	14:32:55
	Time_hmm_12hours	Hours:minutes, 12-hour clock AM/PM, hours without zero	2:35 PM
	Time_hmmss_12hours	Hours:minutes:seconds, 12-hour clock AM/PM, hours without zero	2:32:55 PM
Integer

Date_MMMonth from date in numbers03Date_monthMonth from date in wordsmaartDate_RelativeToToday_InWordsDate relative to today in words1 year, 2 months and 26 days agoDate_shortmonthAbreviated month from datemrtDate_YearYear from date in wordstweeduizend negenDate_yyyyYear from date in numbers2009Date_yyyyMMdd_MinSepyear-month-day, in numbers with zero's2009-03-19Date_yyyyMMdd_SpaceSepyear month in words day, in numbers with zero's2009 03 19Date_yyyymonthdd_MinSepmonth day year, in numbers with zero's, month in words2009-maart-19Date_yyyymonthdd_SpaceSepyear month day, in numbers with zero's2009 maart 19Date_yyyyshortmonthdd_MinSepyear-month short-day, in numbers with zero's2009-mrt-19Date_yyyyshortmonthdd_SlashSepyear/month short/day, in numbers with zero's2009/mrt/19Date_yyyyshortmonthdd_SpaceSepyear month short day, in numbers with zero's2009 mrt 19DayOfWeekDay of the week, starts on sundayWednesdayDayOfWorkWeekDay of the workweek, starts on mondayThursdayFirstUppercaseCapitalise first word in sentence, rest in smallcaps.A value

	Int_InWords	Integer in words	five hundred and twelve
	Int_MonthInWords	Month in words	January
	RomanNumeralsLow	Write integer in lowercase roman numerals	xxvii
	RomanNumeralsUp	Write integer in uppercase roman numerals	XXVII
Number	Num_1Digit	One digit	1,2
	Num_2Digits	Two digits	1,23
	Num_2Digits_1000Sep	Two digits with thousand separator	500.000,00
	Num_2Digits_InWords	Two digit number in words	veertien elfhonderdste
	Num_2DigitsNoZeros	Two non zero digits	500000,-
	Num_2DigitsNoZeros_1000Sep	Two non zero digits with thousand separator	500.000,-
	Num_3Digits	Three digits	1,234
	Num_3DigitsNoZeros	Three non zero digits	500000,-
	Num_3DigitsNoZeros_1000Sep	Three non zero digits with thousand separator	500.000,-
	Num_4Digits	Four digits	1,2346
	Num_5Digits	Five digits	1,23457
	Num_6Digits	Six digits	1,234568
	Num_Absolute	The absolute value of a number	10


	Num_NoDigits	No digits	500000
	Num_NoDigits_1000Sep	No digits with thousand separator	500.000
	Num_Ordinal_InWords	Ordinal number in words (Dutch and English supported).	third
Percentage	Perc_1Digit_1000Sep	One digit percentage with thousand separator	1.000,2 %
	Perc_2Digit_1000Sep	Two digit percentage with thousand separator	1.000,23 %
	Perc_3Digit_1000Sep	Three digit percentage with thousand separator	1.000,235 %
	Perc_1000Sep	Percentage with thousand separator	1.000,1 % 1.000,23457 %
Other	BankAccountNr_NL	Dutch bank account number	57.15.18.833
	BankAccountNr_NL	Dutch bank account number	57.15.18.833
	SocialSecurityNumber_Dutch	Dutch social security number	1234-56-789
	String_ZipCode_NL	Dutch zip code	1234 AA

Space shortcuts

Page tree

Versions Compared

Old Version 8

New Version Current

Key