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

Mask types overview

The following mask types are available in the Blueriq library: 


Mask typeBase typeDescription
AQ_DatePatterndate, dateTimeApplies a date(-time) format with a specific pattern to a date(-time) value.
AQ_FirstToUpperCasestringConverts the first character of a string to upper case and the rest of the string to lowercase.
AQ_NumberPatterninteger, number, currency, percentageApplies a number format with a specific pattern to an numerical value.
AQ_OrdinalNumberintegerDisplays an ordinal number for an integer value.
AQ_RegularExpressionstring, number, integer, currency, percentageReplaces each substring of a string value that matches a given regular expression with the given replacement.
AQ_RomanIntegerintegerDisplays an integer value in roman numerals.
AQ_SetCasestringDisplays a string value in upper or lower
AQ_SpelledBooleanbooleanDisplays a boolean value in words.
AQ_SpelledCurrencycurrencyDisplays a currency value in words.
AQ_SpelledDayOfWeekintegerDisplays a weekday in words.
AQ_SpelledDeltaDatedate, dateTimeDisplays the difference between a date and today in words and integers.
AQ_SpelledIntegerintegerDisplays an integer value in words.
AQ_SpelledMonthintegerDisplays a month in words.
AQ_SpelledNumbernumberDisplays a number value in words.



AQ_DatePattern


Use this mask type to change the way a date or dateTime value is displayed in Blueriq Studio documents.


Parameters

NameDescriptionTypeRequired
date patterna pattern composed of date pattern options and separatorsstringtrue


To define your own date mask you must compose a date pattern using the following options:

Date patternDescription
dDisplays the day as a number without a leading zero.
ddDisplays the day as a number with a leading zero when appropriate.
dayDisplays the day as a number written in words (“one” to “thirty one”).
dayofweekDisplays the day as a full name (“Sunday” to “Saturday”).
MDisplays the month as a number without a leading zero.
MMDisplays the month as a number with a leading zero when appropriate.
monthDisplays the month as a full name (“January” to “December”).
shortmonthDisplays the month as an abbreviation (“Jan to Dec”).
yyDisplays the year as a two-digit number.
yyyyDisplays the year as a four-digit number.
yearDisplays the year as a number written in words (e.g. “two thousand and nine”)
hDisplays the hour as a number without a leading zero, based on the 12-hour clock.
HHDisplays the hour as a number with a leading zero, based on the 24-hour clock.
hhDisplays the hour as a number with a leading zero, based on the 12-hour clock.
mmDisplays the minute as a number with a leading zero.
ssDisplays the second as a number with a leading zero.
aDisplays AM for times from midnight until noon and PM for times from noon until midnight.


The following characters are allowed to be used as separators in a date pattern:

CharacterDescription
-Hyphen
,Comma
.Period
;Semicolon
:Colon

Space


Supported attribute types

  • date

  • dateTime


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

To displayasuse this pattern
12-02-2009Thursday 12 Feb. 09dayofweek dd shortmonth yy
12-02-2009 13:12Thursday 1:12 AMdayofweek h:mm a
12-02-20092009yyyy
12-02-2009February 12 two thousand and ninemonth dd year
12-02-200912/02/2009dd/MM/yyyy

Back to Top



AQ_FirstToUpperCase


Use this mask type to capitalize the first letter of (part of) a string and make the remaining characters lowercase.


Parameters

NameDescriptionTypeRequired
start-indexthe position of the character you want to make uppercasestringfalse
start-indexthe position of the last character to make lowercasestringfalse


Supported attribute types

  • string


Examples

To displayasuse this pattern
a sTrinG ValUEA string valuestart-index:  end-index:
a sTrinG ValUEa String valuestart-index: 2  end-index:
a sTrinG ValUEa String ValUEstart-index: 2  end-index: 7
a sTrinG ValUEA string valuEstart-index:  end-index: 12

Back to Top


AQ_NumberPattern


Use this mask type to change the way a number value is displayed in Blueriq Studio documents.


Parameters

NameDescriptionTypeRequired
pattern

a number format pattern

at least one zero at the end of the decimal syntax is required.
stringtrue
prefixtext string that will be displayed in front of the formatted number valuestringfalse
postfixtext string that will be displayed behind of the formatted number valuestringfalse
zero-fractionstring value that substitutes the fraction part when the fraction is zerostringfalse


Pattern

The pattern syntax: {options}format;negative-spec;positive-spec

  • options
    The option set is optional and must be surrounded with {} when used. It represents a key value mechanism separated by ',' signs.
    Examples include: a=b,q=e meaning a is set to b and q is set to e.
    Valid options are:
    • locale=nl-NL: This specifies a locale in the option set overriding the one of the NumberFormats' class.
  • format
    The format pattern which actually specified how the number should look like consists of a decimal part and an fractional part divided by a '.' when a fractional part is required.
    • decimal
      Decimal part specifies how grouping, minimum decimal and maximum decimal digits. For example a pattern: #,##0 specifies at least 1 decimal digit ( which is always the case ) and grouping every 3 decimal digits. With a maximum of 4 decimal digits. At least 1 zero at the end of the decimal syntax is required for the pattern to parse.
    • fractional
      The fractional part begins if there is a decimal separator '.'. If there is no decimal separator there is no fractional part. The fractional part specifies how many minimum fraction digits there are required and how many fraction digits at max are allowed. For example a syntax 0.00## will specify that at least two fractional should be displayed and at most four.
  • negative-spec
    Negative pattern has only 2 special characters: '#' and ';'. The '#' will dictate the actual number pattern specified earlier. For example: 0.0;(#) will specify that a negative number is prefixed with '(' and postfixed with ')' While ';' will end the pattern part and proceed to the positive specification
  • positive-spec
    The positive pattern has only 1 special character: '#'. The '#' will dictate the actual number pattern specified earlier. For example: 0.0;(#) will specify that a negative number is prefixed with '(' and postfixed with ')'


Supported attribute types

  • number

  • percentage

  • currency

  • integer


Examples

To displayasuse this pattern
500000,00500.000,-pattern: #,##0.00  zero-fraction: -
500000,00€ 500.000,00pattern: #,##0.00  prefix: €
1212,000 %pattern: #,##0.000  postfix: %
-180,12180pattern: #0;#
23+023,00pattern: {locale=NL-nl}000.00;-#;+#

Note that the comma and dot in the pattern are not taken literally; they are just stand-in symbols for the decimal separator and the grouping separator. The actual symbols used depend on the language (locale). For example, the number 1234567.89 with pattern #,##0.00 results in the following numbers, depending on the language used:

  • en-GB (English - United Kingdom): 1,234,567.89 (comma as grouping separator, dot as decimal separator)
  • nl-NL (Dutch): 1.234.567,89 (dot as grouping separator comma as decimal separator)
  • fr-FR (French): 1 234 567,89 (space as grouping separator, comma as decimal separator)

The locale can also be fixed in the pattern, so that the pattern is no longer locale-sensitive. In case you want to have a space as the grouping separator for the number 1234567.89 you should use the {locale=fr-FR}#,##0.00 as pattern, which will result in 1 234 567,89 no matter what language is used for the rest of the project.


when you place a currency sign in front of a number, don’t forget to add a space behind the currency sign. So, write '€ ' instead of '€' in the prefix.

Back to Top


AQ_OrdinalNumber


Use this mask type to display integers in words as ordinal numbers, e.g. “1” will be displayed as “first”.


Parameters

  • none


Supported attribute types

  • integer


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

Displaysas
1first
35thirty-fifth

Back to Top


AQ_RegularExpression


Use this mask type to apply special formatting to numbers or strings. The specified regular expression is used to select parts of the input and replace that with the string that you define in the replace parameter.


Parameters

NameDescriptionTypeRequired
regexp-search

a pattern that selects parts of the input

the regular expressions used in several Blueriq Studio functions are common Java 1.4 expressions. For a complete documentation we refer to the online java documentation.
stringtrue
replacea string to replace the selected parts of the inputstringtrue
touppera boolean value used to apply uppercase before regular expression is evaluatedbooleanfalse
tolowera boolean value used to apply lowercase before regular expression is evaluatedbooleanfalse
prefixa string value that will be added before regular expression is evaluatedstringfalse
postfixa string value that will be added before regular expression is evaluatedstringfalse


Supported attribute types

  • integer

  • number

  • percentage

  • currency

  • string


While parsing a mask of this type the initial input string is transformed in the following order:

  1. changing the case of the string to upper or to lower case

  2. adding the prefix

  3. adding the postfix

  4. performing the regular expression search

  5. completing the transformation using the replace string


Examples

To displayasuse these parameters
1234567891234-56-789regexp-search: 0*([0-9]{4})([0-9]{2})([0-9]{3})$  replace: $1-$2-$3  prefix: 00000000
1234aa1234 AAregexp-search: ([0-9]{4})\s*([A-Z]{2})$  replace: $1 $2  toupper: true
57151883357.15.18.833regexp-search: 0*([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{3})$  replace: $1.$2.$3.$4  prefix: 00000000

Back to Top

AQ_RomanInteger


Use this mask type to display positive integer values as roman numerals.


Parameters

NameDescriptionTypeRequired
case“upper” for uppercase roman numerals  “lower” (default) for lowercase numeralsstringfalse


Supported attribute types

  • positive integer (0 < integer < 1.000.000)


Examples

To displayasuse this parameter
3iiicase: lower
3IIIcase: upper

Back to Top


AQ_SetCase


Us this mask type to make the characters of the selected part of the string uppercase or lowercase.


Parameters

NameDescriptionTypeRequired
case“upper” to convert the selection to uppercase  “lower” (default) to convert the selection to lowercasestringfalse
start-indexthe position of the first character you want to selectstringfalse
end-indexthe position of the last character you want to selectstringfalse


Supported attribute types

  • string


Examples

To displayasuse these parameters
a sTrinG ValUEa string ValUEcase: lower  end-index: 8
a sTrinG ValUEa STRING ValUEcase: upper  start-index: 3  end-index: 8

Back to Top


AQ_SpelledBoolean


Use this mask type to display a boolean value in words.


Parameters

NameDescriptionTypeRequired
shortTRUE for an abbreviated notation  FALSE (default) for whole wordsbooleanfalse


Supported attribute types

  • boolean


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

To displayasuse these parameters
TRUEYesshort: FALSE
TRUEYshort: TRUE

Back to Top


AQ_SpelledCurrency


Use this mask type to display a currency value in words.


Parameters


NameDescriptionTypeRequired
spellzerocentsFALSE (default) to omit converting zero decimal values to words  TRUE to convert zero decimal values to wordsbooleanfalse
currencythe type of currency e.g. euro, dollar, poundstringfalse


Supported attribute types

  • currency


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

To displayasuse this parameters
€ 20,-Twenty euroscurrency: euro
€ 20,-Twenty euros and zero centsspellzerocents: true  currency: euro
$ 20,12Twenty dollars and twelve centscurrency: dollar

Back to Top

AQ_SpelledDayOfWeek


Use this mask type to display an integer value that represents a weekday in words.


Parameters

NameDescriptionTypeRequired
first-day-of-weekthe name of the day that you would want to correspond with 1  options: sunday (=default), monday, tuesday, wednesday, thursday, friday or saturdaystringfalse


Supported attribute types

  • integer


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

To displayasuse this parameter
1Sundayfirst-day-of-week: sunday
1Mondayfirst-day-of-week: monday

Back to Top




AQ_SpelledDeltaDate


Use this mask type to display the difference between a date and today in words and integers.


Parameters

  • none


Supported attribute types

  • date

  • dateTime


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

Let's go back to 2010-03-26.


Displaysas
2010-03-26today
2010-03-251 day ago
2010-02-261 month ago
2010-04-26in 1 month
2009-03-261 year ago
2010-05-10in 1 month and 15 days
2011-06-19in 1 year, 2 months and 24 days
2012-12-20

in 2 years, 8 months and 25 days


Back to Top



AQ_SpelledInteger


Use this mask type to display an integer value in words.


Parameters

  • none


Supported attribute types

  • integer


Supported languages

  • Dutch

  • English

  • af, ba, bg, ca, cpe, cs, cy, da, de, el, eo, es, et, fa, fi, fr, fy, ga, gd, haw, hi, hu, id, is, it, ja, kl, kn, lisu, lt, ml, ms, ne, pap, pl, pt, qu, ro, ru, si, sk, sl, sm, sq, sr, sus, sv, sw, th, tl, tr, vi, yi, yo, zh (see a list of language names)

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

Displaysas
12twelve
25twenty five

Back to Top


AQ_SpelledMonth


Use this mask type to display an integer value representing a month, in words.


Parameters

  • none


Supported attribute types

  • integer (1..12)


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

Displaysas
12December
1January

Back to Top


AQ_SpelledNumber


Use this mask type to display a number value in words.


Parameters

  • none


Supported attribute types

  • number


Supported languages

  • Dutch

  • English

  • af, ba, bg, ca, cpe, cs, cy, da, de, el, eo, es, et, fa, fi, fr, fy, ga, gd, haw, hi, hu, id, is, it, ja, kl, kn, lisu, lt, ml, ms, ne, pap, pl, pt, qu, ro, ru, si, sk, sl, sm, sq, sr, sus, sv, sw, th, tl, tr, vi, yi, yo, zh (see a list of language names)

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

Displaysas
12,5Twelve five tenth
25,1Twenty five one tenth

Back to Top


  • No labels

2 Comments

  1.  The table at AQ_DatePattern is what I was looking for in the page of conversion functions. Maybe it's a good idea to split this onto a seperate page or image and reuse it on the conversion functions page.

    1. Unknown User (m.schadd)