Mask type AQ_RegularExpression

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 Encore 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

Back to Top

Space shortcuts

Page tree

AQ_RegularExpression