Return to FileMaker.com
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.
If ( Length ( Hexvalue ) ≠ length ( Filter ( Lower ( HexValue ) ; "0123456789abcdef" ) ) ; "Bad" )
Retrieving data ...