You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
The listed masks can only be used in documents, e.g. pdf documents.
| Category | Name | Description | Example |
|---|---|---|---|
| String | Acronym | Adds a . behind every character and makes it uppercase | V.A.R.A. |
| AllLowercase | All small caps | a value | |
| AllUppercase | Capitalise all 1 | A VALUE | |
| FirstUppercase | Capitalise first word in sentence, rest in smallcaps. | 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 | donderdag 19 maart 2009 | |
| Date_dd | Day from date in numbers | 19 | |
| Date_ddMM_MinSep | Day-month in numbers with zero's | 19-03 | |
| Date_ddMM_SlashSep | Day/month in numbers with zero's | 19/03 | |
| Date_ddMM_SpaceSep | Day month in numbers with zero's | 19 03 | |
| Date_ddMMyy_MinSep | day-month-year short, in numbers with zero's | 19-03-09 | |
| Date_ddMMyy_SlashSep | day/month/year short, in numbers with zero's | 19/03/09 | |
| Date_ddMMyy_SpaceSep | day month year short, in numbers with zero's | 19 03 09 | |
| Date_ddMMyyyy_MinSep | day-month-year, in numbers with zero's | 19-03-2009 | |
| Date_ddMMyyyy_NoSep | daymonthyear, in numbers with zero's | 19032009 | |
| Date_ddMMyyyy_SlashSep | day/month/year, in numbers with zero's | 19/03/2009 | |
| Date_ddMMyyyy_SpaceSep | day month year, in numbers with zero's | 19 03 2009 | |
| Date_ddmonthyyyy_MinSep | day-month in words-year, in numbers with zero's | 19-maart-2009 | |
| Date_ddmonthyyyy_SlashSep | day/month in words/year, in numbers with zero's | 19/maart/2009 | |
| Date_ddmonthyyyy_SpaceSep | day month in words year, in numbers with zero's | 19 maart 2009 | |
| Date_ddshortmonthyyyy_MinSep | day-month short-year, in numbers with zero's | 19-mrt-2009 | |
| Date_ddshortmonthyyyy_SlashSep | day/month short/year, in numbers with zero's | 19/mrt/2009 | |
| Date_ddshortmonthyyyy_SpaceSep | day month short year, in numbers with zero's | 19 mrt 2009 | |
| Date_dmonthyyyy_SpaceSep | short day month in words year, in numbers with zero's | 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 zero's | 2009-03-19 | |
| Date_yyyyMMdd_SpaceSep | year month in words day, in numbers with zero's | 2009 03 19 | |
| Date_yyyymonthdd_MinSep | month day year, in numbers with zero's, month in words | 2009-maart-19 | |
| Date_yyyymonthdd_SpaceSep | year month day, in numbers with zero's | 2009 maart 19 | |
| Date_yyyyshortmonthdd_MinSep | year-month short-day, in numbers with zero's | 2009-mrt-19 | |
| Date_yyyyshortmonthdd_SlashSep | year/month short/day, in numbers with zero's | 2009/mrt/19 | |
| Date_yyyyshortmonthdd_SpaceSep | year month short day, in numbers with zero's | 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 | |
| Integer | Int_InWords | Integer in words | five hundred and twelve |
| Int_MonthInWords | Month in words | January | |
| RomanNumeralsLow | Write integer in uppercase 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 % | |
| Time | Time_hhmm_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 | |
| 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 |
Overview
Content Tools