AnsweredAssumed Answered

Delete a record if Field A is text or blank

Question asked by Stu412 on Jun 9, 2015
Latest reply on Jun 9, 2015 by Stu412

Title

Delete a record if Field A is text or blank

Post

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?

Thanks

 

Outcomes