You are viewing the documentation for Blueriq 13. Documentation for other versions is available in our documentation directory.

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.

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

CategoryNameDescriptionExample
StringAcronymAdds a dot (.) behind every character and makes it uppercaseV.A.R.A.

AllLowercaseAll small capsa value

AllUppercaseCapitalize allA VALUE

FirstUppercaseCapitalize first word in sentence, rest in small caps.A value
BooleanBool_InWordsBoolean in wordsyes

Bool_InWordsAbbrBoolean in words abbreviatedy
CurrencyCurr_Dollar_ValueInWordsDollar value in wordsFivehundred dollar and twelve cents

Curr_Dollar_ValueInWords_ZeroCentsDollar value in words, zero centsFivehundred dollar and zero cents

Curr_Euro_2Digits_1000SepEuro value, two digits with thousand separator€ 500.000,00

Curr_Euro_2DigitsNoZerosEuro value, two non zero digits€ 500000,-

Curr_Euro_2DigitsNoZeros_1000SepEuro value, two non zero digits with thousand separator€ 500.000,-

Curr_Euro_3DigitsNoZerosEuro value, three non zero digits€ 500000,-

Curr_Euro_3DigitsNoZeros_1000SepEuro value, three non zero digits with thousand separator€ 500.000,-

Curr_Euro_NoDigitsEuro value, no digits€ 500000

Curr_Euro_NoDigits_1000SepEuro value, no digits with thousand separator€ 500.000

Curr_Euro_ValueInWordsEuro value in wordsFivehundred euros and twelve cents

Curr_Euro_ValueInWords_ZeroCentsEuro value in words, zero centsFivehundred euros and zero cents

Curr_Pound_ValueInWordsPound value in wordsFivehundred pound and twelve pence

Curr_Pound_ValueInWords_ZeropenniesPound value in words, zero penceFivehundred pound and twelve pence
DateDate_dayDay from date in wordsnegentien

Date_dayofweekWeek daydonderdag

Date_dayofweekddmonthyyyy_SpaceSepweekday day month in words year, in numbers with zerosdonderdag 19 maart 2009

Date_ddDay from date in numbers19

Date_ddMM_MinSepDay-month in numbers with zeros19-03

Date_ddMM_SlashSepDay/month in numbers with zeros19/03

Date_ddMM_SpaceSepDay month in numbers with zeros19 03

Date_ddMMyy_MinSepday-month-year short, in numbers with zeros19-03-09

Date_ddMMyy_SlashSepday/month/year short, in numbers with zeros19/03/09

Date_ddMMyy_SpaceSepday month year short, in numbers with zeros19 03 09

Date_ddMMyyyy_MinSepday-month-year, in numbers with zeros19-03-2009

Date_ddMMyyyy_NoSepdaymonthyear, in numbers with zeros19032009

Date_ddMMyyyy_SlashSepday/month/year, in numbers with zeros19/03/2009

Date_ddMMyyyy_SpaceSepday month year, in numbers with zeros19 03 2009

Date_ddmonthyyyy_MinSepday-month in words-year, in numbers with zeros19-maart-2009

Date_ddmonthyyyy_SlashSepday/month in words/year, in numbers with zeros19/maart/2009

Date_ddmonthyyyy_SpaceSepday month in words year, in numbers with zeros19 maart 2009

Date_ddshortmonthyyyy_MinSepday-month short-year, in numbers with zeros19-mrt-2009

Date_ddshortmonthyyyy_SlashSepday/month short/year, in numbers with zeros19/mrt/2009

Date_ddshortmonthyyyy_SpaceSepday month short year, in numbers with zeros19 mrt 2009

Date_dmonthyyyy_SpaceSepshort day month in words year, in numbers with zeros1 maart 2009

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 zeros2009-03-19

Date_yyyyMMdd_SpaceSepyear month in words day, in numbers with zeros2009 03 19

Date_yyyymonthdd_MinSepmonth day year, in numbers with zeros, month in words2009-maart-19

Date_yyyymonthdd_SpaceSepyear month day, in numbers with zeros2009 maart 19

Date_yyyyshortmonthdd_MinSepyear-month short-day, in numbers with zeros2009-mrt-19

Date_yyyyshortmonthdd_SlashSepyear/month short/day, in numbers with zeros2009/mrt/19

Date_yyyyshortmonthdd_SpaceSepyear month short day, in numbers with zeros2009 mrt 19

DayOfWeekDay of the week, starts on SundayWednesday

DayOfWorkWeekDay of the workweek, starts on MondayThursday
Date & timeDate_ddMMyy_hhmm_12hoursDay-month-year(short) hours:minutes, 12-hour clock03-12-09 02:32 PM

Date_ddMMyy_hhmmss_12hoursDay-month-year(short) hours:minutes:seconds, 12-hour clock03-12-09 02:32:55 PM

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

Date_ddMMyyyy_hhmm_12hoursDay-month-year hours:minutes, 12-hour clock03-12-2009 02:32 PM

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_dMMyy_HHmmss_24hoursDay-month-year(short) hours:minutes:seconds, 24-hour clock3-12-09 14:32:55

Date_dMMyy_hmm_12hoursDay-month-year(short) hours:minutes, 12-hour clock3-12-09 2:32 PM

Date_dMMyy_hmmss_12hoursDay-month-year(short) hours:minutes:seconds, 12-hour clock3-12-09 2:32:55 PM

Date_dMMyyyy_HHmmss_24hoursDay-month-year hours:minutes:seconds, 24-hour clock3-12-2009 14:32:55

Date_dMMyyyy_hmm_12hoursDay-month-year hours:minutes, 12-hour clock3-12-2009 2:32 PM

Date_dMMyyyy_hmmss_12hoursDay-month-year hours:minutes:seconds, 12-hour clock3-12-2009 2:32:55 PM

Date_dmonthyyyy_HHmmss_24hoursDay month(long) year hours:minutes, 24-hour clock3 december 2009 14:32 PM

Date_dmonthyyyy_hmm_12hoursDay month(long) year hours:minutes, 12-hour clock3 december 2009 2:32 PM
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_12hoursHours:minutes:seconds, 12-hour clock AM/PM, hours without zero2:32:55 PM
IntegerInt_InWordsInteger in wordsfive hundred and twelve

Int_MonthInWordsMonth in wordsJanuary

RomanNumeralsLowWrite integer in lowercase roman numeralsxxvii

RomanNumeralsUpWrite integer in uppercase roman numeralsXXVII
NumberNum_1DigitOne digit1,2

Num_2DigitsTwo digits1,23

Num_2Digits_1000SepTwo digits with thousand separator500.000,00

Num_2Digits_InWordsTwo digit number in wordsveertien elfhonderdste

Num_2DigitsNoZerosTwo non zero digits500000,-

Num_2DigitsNoZeros_1000SepTwo non zero digits with thousand separator500.000,-

Num_3DigitsThree digits1,234

Num_3DigitsNoZerosThree non zero digits500000,-

Num_3DigitsNoZeros_1000SepThree non zero digits with thousand separator500.000,-

Num_4DigitsFour digits1,2346

Num_5DigitsFive digits1,23457

Num_6DigitsSix digits1,234568

Num_AbsoluteThe absolute value of a number10

Num_NoDigitsNo digits500000

Num_NoDigits_1000SepNo digits with thousand separator500.000

Num_Ordinal_InWordsOrdinal number in words (Dutch and English supported).third
PercentagePerc_1Digit_1000SepOne digit percentage with thousand separator1.000,2 %

Perc_2Digit_1000SepTwo digit percentage with thousand separator1.000,23 %

Perc_3Digit_1000SepThree digit percentage with thousand separator1.000,235 %

Perc_1000SepPercentage with thousand separator1.000,1 % 1.000,23457 %
OtherBankAccountNr_NLDutch bank account number57.15.18.833

BankAccountNr_NLDutch bank account number57.15.18.833

SocialSecurityNumber_DutchDutch social security number1234-56-789

String_ZipCode_NLDutch zip code1234 AA
  • No labels