Nothing to do with the web.
I am producing a simple data entry form. A column is supposed to take in 9 digits from scan reading students ID cards and storing it.
e.g., if a student ID card contains B000067465-X, I want it to be able to knock off the initial B and the last two digits -X leaving just 9 numeric characters 000067465.
Can this be done at the rule validation table creation level or not. If possible, how?
This would just save me eventually writing VB