You are viewing the documentation for Blueriq 15. Documentation for other versions is available in our documentation directory.
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
Name | Description | Type | Required |
---|---|---|---|
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.
| string | true |
replace | a string to replace the selected parts of the input | string | true |
toupper | a boolean value used to apply uppercase before regular expression is evaluated | boolean | false |
tolower | a boolean value used to apply lowercase before regular expression is evaluated | boolean | false |
prefix | a string value that will be added before regular expression is evaluated | string | false |
postfix | a string value that will be added before regular expression is evaluated | string | false |
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
To display | as | use these parameters |
---|---|---|
123456789 | 1234-56-789 | regexp-search: 0*([0-9]{4})([0-9]{2})([0-9]{3})$ replace: $1-$2-$3 prefix: 00000000 |
1234aa | 1234 AA | regexp-search: ([0-9]{4})\s*([A-Z]{2})$ replace: $1 $2 toupper: true |
571518833 | 57.15.18.833 | regexp-search: 0*([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{3})$ replace: $1.$2.$3.$4 prefix: 00000000 |
Overview
Content Tools