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

    Validate Hex Numbers

    SandyHaaf

      Title

      Validate Hex Numbers

      Post

           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.

           Sandy