L
Liz J
Hi
I have a table that I have set up and I want the Customer ID to have an
input mask of LLL0000 (I think that is 3 mandatory letters followed by 4
mandatory numbers).
I set up the input mask and then I need to import data to the table from a
txt file. I am using the import text wizard for this that I find in File,
Get external data.
The data comes into the table fine but I need it to trap any Customer ID
that does not conform to the input mask and it is not doing so.
How can I set an input mask (or validation) that will trap any Customer IDs
that do not follow the correct pattern?
TIA
Liz
I have a table that I have set up and I want the Customer ID to have an
input mask of LLL0000 (I think that is 3 mandatory letters followed by 4
mandatory numbers).
I set up the input mask and then I need to import data to the table from a
txt file. I am using the import text wizard for this that I find in File,
Get external data.
The data comes into the table fine but I need it to trap any Customer ID
that does not conform to the input mask and it is not doing so.
How can I set an input mask (or validation) that will trap any Customer IDs
that do not follow the correct pattern?
TIA
Liz