Page History
...
Mask types overview
The following mask types are available in the
...
BlueriqBasicModelling Library:
...
Mask type | Base type | Description |
---|---|---|
AQ_DatePattern | date, dateTime | Applies a date(-time) format with a specific pattern to a date(-time) value. |
AQ_FirstToUpperCase | string | Converts the first character of a string to upper case and the rest of the string to lowercase. |
AQ_NumberPattern | integer, number, currency, percentage | Applies a number format with a specific pattern to an numerical value. |
AQ_OrdinalNumber | integer | Displays an ordinal number for an integer value. |
AQ_RegularExpression | string, number, integer, currency, percentage | Replaces each substring of a string value that matches a given regular expression with the given replacement. |
AQ_RomanInteger | integer | Displays an integer value in roman numerals. |
AQ_SetCase | string | Displays a string value in upper or lower |
AQ_SpelledBoolean | boolean | Displays a boolean value in words. |
AQ_SpelledCurrency | currency | Displays a currency value in words. |
AQ_SpelledDayOfWeek | integer | Displays a weekday in words. |
AQ_SpelledDeltaDate | date, dateTime | Displays the difference between a date and today in words and integers. |
AQ_SpelledInteger | integer | Displays an integer value in words. |
AQ_SpelledMonth | integer | Displays a month in words. |
AQ_SpelledNumber | number | Displays a number value in words. |
Include Page | ||
---|---|---|
|
You can use this mask type when you want to create masks that change the way a date or dateTime value is displayed in Aquima Studio documents.
Parameters
...
To define your own date mask you must compose a date pattern using the following options:
...
The following characters are allowed to be used as separators in a date-time mask:
...
Supported attribute types
- date
- dateTime
Supported languages 1)
- Dutch
- English
Examples
...
AQ_FirstToUpperCase
You can use this mask type to capitalise the first letter of (part of) a string and make the remaining characters lowercase.
Parameters
...
Supported attribute types
- string
Examples
...
AQ_NumberPattern
You can use this mask type when you want to create masks that change the way a number value is displayed in Aquima Studio documents.
Parameters
...
Supported attribute types
- number
- percentage
- currency
- integer
Examples
...
AQ_OrdinalNumber
This mask type is used to display integers in words as ordinal numbers, e.g. “1” will be displayed as “first”.
Parameters
- none
Supported attribute types
- integer
Supported languages 2)
- Dutch
- English
Examples
...
AQ_RegularExpression
This mask type is used to create special formatting of 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
...
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:
- changing the case of the string to upper or to lower case
- adding the prefix
- adding the postfix
- performing the regular expression search
- completing the transformation using the replace string
Examples
...
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|
AQ_RomanInteger
This mask type is used to display positive integer values as roman numerals.
Parameters
...
Supported attribute types
- positive integer 1)
Examples
...
AQ_SetCase
This mask type is used to make the characters of the selected part of the string uppercase or lowercase.
Parameters
...
Supported attribute types
- string
Examples
...
AQ_SpelledBoolean
This mask type is used to display a boolean value in words.
Parameters
...
Supported attribute types
- boolean
Supported languages 3)
- Dutch
- English
Examples
...
AQ_SpelledCurrency
This mask type is used to display a currency value in words.
Parameters
...
Supported attribute types
- currency
Supported languages 4)
- Dutch
- English
Examples
...
AQ_SpelledDayOfWeek
This mask type is used to display an integer value that represents a weekday in words.
Parameters
...
Supported attribute types
- integer
Supported languages 5)
- Dutch
- English
Examples
...
AQ_SpelledDeltaDate
This mask type is used to display the difference between a date and today in words and integers.
Parameters
- none
Supported attribute types
- date
- dateTime
Supported languages 6)
- Dutch
- English
Examples
Let's go back to 2010-03-26.
...
AQ_SpelledInteger
This mask type is used to display an integer value in words.
Parameters
- none
Supported attribute types
- integer
Supported languages 7)
- 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)
Examples
...
AQ_SpelledMonth
This mask type is used to display an integer value representing a month, in words.
Parameters
- none
Supported attribute types
- integer (1..12)
Supported languages 8)
- Dutch
- English
Examples
...
AQ_SpelledNumber
This mask type displays a number value in words.
Parameters
- none
Supported attribute types
- number
Supported languages 9)
- 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)
Examples
...