Condition node - how to discard if field contains alpha characters?

Question

I'm having a hard time trying to find what to place in a condition node to look in PID-3.1 and if it contains alpha characters (we only want to keep ones with just numbers in this field) then discard.

Thanks in advance for any help.

Answer 1

One way is to set the condition node to be 'Custom' and use this code:

return StringUtils.isNumeric(source.getNode('PID-3'.1));

This will look at the field in the source message and, if it is just numbers, return true.  Otherewise, it will return false, which will cause the condition to fail.  

 

Comments

Thank you, works as needed.