Checking for text values in a text field
Posted on 2003-10-27
Bit of a dodgy explanation so sorry about that.
I have an agent which loops through all unprocessed documents. It looks for a text field (called equipment code) and if the value contains a number only I use CInt so that I can determine what the numeric value is and then set various flags on the document.
The problem is if the text field contains non numeric values a type mismatch error will be generated and the agent fails.
So I want to be able to check for non numeric values. If text is found then I do not do the CInt and move to the next document. Otherwise I do the CInt and continue with the rest of the agent.
Surely can't be that hard!?