Versions Compared

Old Version 1

changes.mady.by.user Unknown User (a.jansen)

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (a.jansen)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

Panel

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

UI Text Box
typenote
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

Panel
NameDescriptionTypeRequired
regexp-search

a pattern that selects parts of the input

UI Text Box
typeinfo
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
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

Panel

AQ_RomanInteger

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

Parameters

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

Supported attribute types

  • positive integer (0 < integer < 1.000.000)

Examples

To displayasuse this parameter3iiicase: lower3IIIcase: upper

Back to top

Panel

AQ_SetCase

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

Parameters

NameDescriptionTypeRequiredcase“upper” to convert the selection to uppercase  “lower” (default) to convert the selection to lowercasestringfalsestart-indexthe position of the first character you want to selectstringfalseend-indexthe position of the last character you want to selectstringfalse

Supported attribute types

  • string

Examples

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

Back to top

Panel

AQ_SpelledBoolean

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

Parameters

NameDescriptionTypeRequiredshortTRUE for an abbreviated notation  FALSE (default) for whole wordsbooleanfalse

Supported attribute types

  • boolean

Supported languages

  • Dutch

  • English

UI Text Box
typenote
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 parametersTRUEYesshort: FALSETRUEYshort: TRUE

Back to top

Panel

AQ_SpelledCurrency

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

Parameters

NameDescriptionTypeRequiredspellzerocentsFALSE (default) to omit converting zero decimal values to words  TRUE to convert zero decimal values to wordsbooleanfalsecurrencythe type of currency e.g. euro, dollar, poundstringfalse

Supported attribute types

  • currency

Supported languages

  • Dutch

  • English

UI Text Box
typenote
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

Panel

AQ_SpelledDayOfWeek

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

Parameters

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

UI Text Box
typenote
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 parameter1Sundayfirst-day-of-week: sunday1Mondayfirst-day-of-week: monday

Back to top

Panel

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

UI Text Box
typenote
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.

Displaysas2010-03-26today2010-03-251 day ago2010-02-261 month ago2010-04-26in 1 month2009-03-261 year ago2010-05-10in 1 month and 15 days2011-06-19in 1 year, 2 months and 24 days2012-12-20

in 2 years, 8 months and 25 days

Back to top

Panel

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)

UI Text Box
typenote
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

Displaysas12twelve25twenty five

Back to top

Panel

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

UI Text Box
typenote
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

Displaysas12December1January

Back to top

Panel

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)

UI Text Box
typenote
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

Displaysas12,5Twelve five tenth25,1Twenty five one tenth

Back to top