Newbies Kericomp Posted November 15, 2002 Newbies Share Posted November 15, 2002 I have been using ABS(field) to test if field is numeric or text. This works for all text except words that start with the letter T. The abs() of "T" returns a value of 1. For any other letter it is blank. Why is this so??? Is it a special feature in Filemaker 4.1? Link to comment Share on other sites More sharing options...
BobWeaver Posted November 15, 2002 Share Posted November 15, 2002 It's interpreting the T as the boolean value "true" which is stored internally as the value 1. Try using this test: NumToText(TextToNum(field))=field Link to comment Share on other sites More sharing options...
Newbies Kericomp Posted November 15, 2002 Author Newbies Share Posted November 15, 2002 AHA! that explains why the letter "F" returns a zero and not a blank. thanks Link to comment Share on other sites More sharing options...
BobWeaver Posted November 15, 2002 Share Posted November 15, 2002 Also, Y and N will return 1 and 0. Link to comment Share on other sites More sharing options...
Vaughan Posted November 15, 2002 Share Posted November 15, 2002 Use the TextToNum() function. It'll strip out all text and just leave the numbers nicely. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7925 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now