Input Format |
  
|
Input Format |
|
For Numeric field and Text field, user can use Input format for entering Data . If the Numeric Field or Textfield is blank initially, the data entry format is displayed in it and data entry will be restricted to the given Input format in the Preview. Once the data is entered, the display format will be followed as per display format definition.
Format |
Description |
# |
Displays lowercase and uppercase alphabets or Numbers in input area. You can specify the number of characters by entering "#" desired number of times. An "_" is displayed on data entry area till the defined number of characters. |
9 |
Displays numeric characters in input area. You can specify the number of digits by entering "9" desired number of times. An "_" is displayed on data entry area till the defined number of characters. |
Z |
Displays alphabetic characters in input area. You can specify the number of alphabets by entering desired number of "Z" characters. If it is "z", input data will be restricted for letters in lowercase.An "_" is displayed on data entry area till the defined number of characters. |
^ |
Displays lowercase and uppercase alphabets. |
, |
Displays comma for each specified position. |
. |
Display one numeric point character. |
_ |
Display one text character in input area. It allows to enter any data. |
any other characters |
Display the characters in input area but does not allow to edit. |
In case of Date or Date Number, following are additionally supported.
Format |
Description |
YYYY |
Year 4 digit number |
MM |
Month 2 digit number. 0 suffix. Range is from 1 to 12. |
DD |
Day 2 digit number . 0 suffix. Range is from 1 to 31. |
HH |
Hour 2 digit number . 0 suffix. 24 hours per day. Range is from 0 to 23. |
mm |
minutes 2 digit number . 0 suffix. Range is from 0 to 59 |
SS |
Second 2 digit number . 0 suffix. Range is from 0 to 59. |