PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
CURRENCY [$€£¥%]?|(~.{1,10}~)? Character of the currency (example: ~ EUR~ )
CURRENCY_POS \<|\>? < CURRENCY position (<)left (>)right
THOUSANDS_SEP [,\._]? Thousands separator character
SIGN [\[\(+-]? - The + sign indicates that it only allows positive numbers. The characters [ or ( will cause the number to be enclosed in square brackets or parentheses when negative.
SIGN_POS \<|\>? < Position of the minus sign (<)left (>)right
FILL [0_\*]? Filling to the left of the indicated character until the SIZE is filled
SIZE [0-9]{1,} Size of number positions including decimals
DECIMALS_SEP [,\._]? Decimal separator character
DECIMALS [0-9]* 0 Number of decimal positions
BLANK_IF_ZERO B? If the number is zero, leave it blank
ALIGN [LCR]? R Alignment of the text when editing (L)left (C)center (R)right
PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
SIZE [0-9]{1,} Size of number positions including decimals
CASE [ ULCA]? Convert text to (U)uppercase (L)lowercase (C)capitalize first (A)capitalize all
REAC Regular expression - Allowed Chars
REVA Regular expression - Validation on change
RETY Regular expression - Typing Allowed Chars
PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
FORMAT [0-9]+|.+ Format identifier:
  • 1 - d/m/Y
  • 2 - d/m/y
  • 3 - m/d/Y
  • 4 - m/d/y
  • 5 - Y/m/d
  • 6 - Y/d/m
SEPARATOR [\/,\-\.\_]? / Separator character for day, month and year. (_) indicates a blank space
PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
FORMAT [0-9]+|.+ Format identifier
SEPARATOR [:,\-\.\_]? : Separator character for hours, minutes and seconds. (_) indicates a blank space
PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
FORMAT [0-9]+|.+ Format identifier
SEPARATOR [:,\-\.\_]? : Separator character for hours, minutes and seconds. (_) indicates a blank space
PICTURE
TEST
PARAM POSSIBLE VALUES DEFAULT VALUE NOTES
FORMAT (?[^~])|(?(~[^~]*~)) Format identifier. Use:
  • < - for numbers 0-9 or a blank space
  • # - for numbers 0-9
  • a - one character a-z
  • â - one character a-z or a blank space
  • A - one character A-Z
  • Â - one character A-Z or a blank space
  • * - any char
  • ~.*~ - any char between ~~ will be shown but not editable