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

Capitalise

Capitalize first word in sentence, rest in

smallcaps

small caps.	A value
Boolean	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 clock03-12-09 02:32:55 PM

SlashSep

day/month/year short, in numbers with zeros

19/03/09


	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 clock03-12-2009 02:32 PM

, in numbers with zeros	19-maart-2009
	Date_ddmonthyyyy_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_12hoursDay-month-year hours:minutes:seconds, 12-hour clock03-12-2009 02:32:55 PM Date_ddMMyyyy_HHmmss_24hoursDay-month-year hours:minutes:seconds, 24-hour clock03-12-2009 14:32:55 Date_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_

ddMMyyyy

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_yyyyMMdd_MinSep	year-month-day, in numbers with zeros	2009-03-19
	Date_yyyyMMdd_SpaceSep	year month in words day, in numbers with zeros	2009 03 19
	Date_yyyymonthdd_MinSep	month day year, in numbers with zeros, month in words	2009-maart-19
	Date_yyyymonthdd_SpaceSep	year month day, in numbers with zeros	2009 maart 19
	Date_yyyyshortmonthdd_MinSep	year-month short-day, in numbers with zeros	2009-mrt-19
	Date_yyyyshortmonthdd_SlashSep	year/month short/day, in numbers with zeros	2009/mrt/19
	Date_yyyyshortmonthdd_SpaceSep	year month short day, in numbers with zeros	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

19 03 2009 Date_ddmonthyyyy_MinSepday-month in words-year, in numbers with zero's19-maart-2009 Date_ddmonthyyyy_SlashSepday/month in words/year, in numbers with zero's19/maart/2009 Date_ddmonthyyyy_SpaceSepday month in words year, in numbers with zero's19 maart 2009 Date_ddshortmonthyyyy_MinSepday-month short-year, in numbers with zero's19-mrt-2009 Date_ddshortmonthyyyy_SlashSepday/month short/year, in numbers with zero's19/mrt/2009 Date_ddshortmonthyyyy_SpaceSepday month short year, in numbers with zero's19 mrt 2009


	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

Date_MMMonth from date in numbers03 Date_monthMonth from date in wordsmaart Date_RelativeToToday_InWordsDate relative to today in words1 year, 2 months and 26 days ago Date_shortmonthAbreviated month from datemrt Date_YearYear from date in wordstweeduizend negen Date_yyyyYear from date in numbers2009 Date_yyyyMMdd_MinSepyear-month-day, in numbers with zero's2009-03-19 Date_yyyyMMdd_SpaceSepyear month in words day, in numbers with zero's2009 03 19 Date_yyyymonthdd_MinSepmonth day year, in numbers with zero's, month in words2009-maart-19 Date_yyyymonthdd_SpaceSepyear month day, in numbers with zero's2009 maart 19 Date_yyyyshortmonthdd_MinSepyear-month short-day, in numbers with zero's2009-mrt-19 Date_yyyyshortmonthdd_SlashSepyear/month short/day, in numbers with zero's2009/mrt/19 Date_yyyyshortmonthdd_SpaceSepyear month short day, in numbers with zero's2009 mrt 19 DayOfWeekDay of the week, starts on sundayWednesday DayOfWorkWeekDay of the workweek, starts on mondayThursday


Integer	Int_InWords	Integer in words	five hundred and twelve


	Int_MonthInWords	Month in words	January


	RomanNumeralsLow	Write integer in

uppercase

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 %

TimeTime_hhmm_12hoursHours:minutes, 12-hour clock AM/PM, with zero`s02:32 PM Time_HHmm_24hoursHours:minutes, 24-hour clock14:32 Time_hhmmss_12hoursHours:minutes:seconds, 12-hour clock AM/PM, with zero`s02:32:55 PM Time_HHmmss_24hoursHours:minutes:seconds, 24-hour clock14:32:55 Time_hmm_12hoursHours:minutes, 12-hour clock AM/PM, hours without zero2:35 PM Time_hmmss_12hours

Hours:minutes:seconds, 12-hour clock AM/PM, hours without zero2:32:55 PM

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 11

New Version Current

Key