Delete a record if Field A is text or blank
I'm working on a data import routine and it needs to be built to the lowest denominator of ease of use. On the import file, which I don't want to have users changing, one of the columns I will rely on contains a mix of codes (which are numeric and needed) and text (which can be removed).
It so happens that each record on the import with a text entry in this particular field is removable.
I'm thinking of a calc which would evaluate this column on import, something like "If Code is not number, then delete record".
Simple question - in a data field that could contain text or a number, how do I test for either?