I have a field which is defined as alphanumeric and the user has to enter values in this field in format of NNNC, where N = numeric and C = character. Also, the last bit (character), can take values only 'D', 'M','W' and 'Y'. So, how can I make a check on this field so that valid values are entered. So, basically I need to validate tha the first 3 are numeric and the 4th field is either D /M/W/Y.
If numeric-char-is-numeric in first-numeric-char
numeric-char-is-numeric in second-numeric-char
numeric-char-is-numeric in third-numeric-char
by the way, this is not a rookie or beginners forum.
happy new year, rookie!