Geneos - How to determine if the value in a cell is a number or a string

This demonstrates use of the inList and regMatch functions to check simple use cases to check if a cell has certain numerical values. 

For example, if the value is not empty and is in the range of 1 to 10 then set it to OK.
 

if value unlike "" and inList(value, "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10") then
  severity ok
else
  severity warning
endif

 

For a more advanced check, you could come up with your regex expression for a more precise match the below example will check for pure positive whole numerical values .
 
Applying the rule block to the column values below will set the severity as shown:
 

if value unlike "" and regMatch(value, "^0$|^([1-9][0-9]*)$") then
  severity ok
else
  severity warning
endif

•  Rules Actions Alerts

If you have any further questions:

• Please contact with our Client Services team via the chat service box available in any of our websites or via email to support@itrsgroup.com
  
  
  
• Make sure you provide to us:
  • ANY LOG FILE OR DIAGNOSTIC
  • ANY SCREENSHOT