Scrutinize a data field to determine whether it contains alpha numeric data

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Join our Lavastorm Users Group on LinkedIn to stay up to date on Lavastorm Analytics news, events and products. Customer input is invaluable to us and we welcome your participation.

Scrutinize a data field to determine whether it contains alpha numeric data

I have an output pin with 4 columns and about 1 million records.
One of the columns (unit_address field) contains a data string with 8-16 characters. I would like to scrutinize that data field (unit_address) to determine whether it contains any letters. if it does contain at least one letter, i want to output it to a different output on a filter pin.

Example:
if unit_address field contains this data "000000194737AB36", I would like to have it output to pin 1 and taged as an alphanumeric data.
if unit_address field contains this data "0001102639416036", I would like to have it output to pin 2 and taged as an numeric data.

Looking for the simplest way to do this with consideration to the record count being over a million.

Just to clarify further, isDigit requires the source field to be a string; you can also use the isNumber operator which evaluates any expression. There are also string operators for isAlpha and isAlphaNum which evaluate for alpha and alpha numeric strings accordingly.