Test if value is numeric

[trentonponder]

I'm using OCR and frequently the characters are not pulled in correctly (not entirely unexpected).

The characters I want are always numeric. Is there a way to force AA to test if a value is numeric, such as:

'Loop while variable is not numeric'


I could potentially put the value into Excel or a DB and test there but that would add to the complexity and pace of the task

[TylerMitton]

I just did a quick test... if you take the value you want to check to see if it is an int and divide it by 0 using a variable operations of: $Value$/0 you might get what you need.

You can check the result and if it equals:

1.#INF

Then it is an int, otherwise it isn't.

See attached task for an example... hope it helps!

Tyler

[trentonponder]

Thanks Tyler, worked great!