AnsweredAssumed Answered

Validate Hex Numbers

Question asked by SandyHaaf on Mar 8, 2013
Latest reply on Mar 8, 2013 by philmodjunk


Validate Hex Numbers


     I am importing a bunch of hex numbers.  Once they are imported into a temporary table.  I am running a script that will validate some of the data.


     So I have an if Statement that basically says if Length(HexValue) > 4 then Set Status = "Bad"

     I'd like to add another IF that says if all the characters in HEXValue are not in (1,2,3,4,5,6,7,8,9,a,b,c,d,e,f) then set Status = "Bad"


     But I can't find a function that can do that.  


     So I figure b/n these 2 IF's I have then validated that all records not marked as Bad have valid hex values.

     As always I appreciate your help.