Difference between revisions of "Input Masks"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 43: | Line 43: | ||
|valign="top"|@C, @C2, @C4||Currency: currency symbol followed by digits 0-9, comma for thousands and one decimal point. @C and @C2 indicate 2 decimal places; @C4 4 decimal places. | |valign="top"|@C, @C2, @C4||Currency: currency symbol followed by digits 0-9, comma for thousands and one decimal point. @C and @C2 indicate 2 decimal places; @C4 4 decimal places. | ||
|- | |- | ||
− | |valign="top"|@D||Date: ISO date YYYY-MM-DD | + | |valign="top"|@D||Date: ISO date YYYY-MM-DD. |
|- | |- | ||
|valign="top"|@E||Email: | |valign="top"|@E||Email: | ||
Line 49: | Line 49: | ||
|valign="top"|@F||Number: accepts +/- prefix followed by digits 0-9 and one decimal point. | |valign="top"|@F||Number: accepts +/- prefix followed by digits 0-9 and one decimal point. | ||
|- | |- | ||
− | |valign="top"|@X||Text: accepts alphanumeric characters | + | |valign="top"|@X||Text: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. |
|- | |- | ||
− | |valign="top"|@T||Time: | + | |valign="top"|@T||Time: hh:mm:ss. |
|- | |- | ||
− | |valign="top"|@A||Alphabetic: accepts alphabetic characters only | + | |valign="top"|@A||Alphabetic: accepts alphabetic characters a-z, A-Z only. |
|- | |- | ||
− | |valign="top"|@!||Upper Case | + | |valign="top"|@!||Upper Case: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. Lower case alphabetic characters are converted to upper case. |
|- | |- | ||
− | |valign="top"|@^||Upper Case Alphabetic | + | |valign="top"|@^||Upper Case Alphabetic: : accepts alphabetic characters a-z, A-Z only. Lower case alphabetic characters are converted to upper case. |
|- | |- | ||
|valign="top"|@I#,#,#||Integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000 | |valign="top"|@I#,#,#||Integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000 | ||
Line 65: | Line 65: | ||
|valign="top"|?<regular expression>||Regular expression: prefix with '?' to indicate a regular expression. e.g. ?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b | |valign="top"|?<regular expression>||Regular expression: prefix with '?' to indicate a regular expression. e.g. ?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b | ||
|- | |- | ||
− | |valign="top"|!A9X||VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99. | + | |valign="top"|!A9X||VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99.<br> ! upper case<br>A alphabetic<br>9 numeric<br>X alphanumeric. |
|- | |- | ||
|} | |} |
Revision as of 13:34, 2 February 2015
Under Construction
Input mask type
Available in Form Section and Canvas Section fields.
Using the named pictures requires a bound data source: a field from a table, or a memory variable (m.memvar) with a default expression to specify the width of the corresponding picture.
Select from the listed options. This will populate the mask as follows:
Type | Mask |
---|---|
Custom | Not populated. |
Currency | @C2 |
Date | @D |
Email Address | @E |
Number | @F |
Text | @X |
Time | @T |
Alphabetic | @A |
Upper Case | @! |
Upper Case Alphabetic | @^ |
Custom input masks
Mask | Description |
---|---|
@C, @C2, @C4 | Currency: currency symbol followed by digits 0-9, comma for thousands and one decimal point. @C and @C2 indicate 2 decimal places; @C4 4 decimal places. |
@D | Date: ISO date YYYY-MM-DD. |
@E | Email: |
@F | Number: accepts +/- prefix followed by digits 0-9 and one decimal point. |
@X | Text: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. |
@T | Time: hh:mm:ss. |
@A | Alphabetic: accepts alphabetic characters a-z, A-Z only. |
@! | Upper Case: accepts alphanumeric characters a-z, A-Z, digits 0-9 and printable symbols. Lower case alphabetic characters are converted to upper case. |
@^ | Upper Case Alphabetic: : accepts alphabetic characters a-z, A-Z only. Lower case alphabetic characters are converted to upper case. |
@I#,#,# | Integer value with maxlength,minvalue,maxvalue: e.g. @I10,100,1000 |
@F#,#,# | Double value with maxlength,maxdecimals,minvalue,maxvalue: e.g. @F10,2,0,10000 |
?<regular expression> | Regular expression: prefix with '?' to indicate a regular expression. e.g. ?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b |
!A9X | VFP-style picture characters: each picture character corresponds to a character in the value, e.g. AAA, A99. ! upper case A alphabetic 9 numeric X alphanumeric. |
@9,3
That will restrict to 3 digits.
@9,3,5,200
That will restrict to 3 digits in the range 5 to 200