1 Reply Latest reply on Mar 8, 2013 1:01 PM by philmodjunk

    Validate Hex Numbers



      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.