K1200 Posted February 14, 2009 Posted February 14, 2009 Would anyone happen to know of a simple way to test that a field actually has some printable characters in it -- and not just blanks, tabs, carriage returns and the like. I'd like to be able to set a Yes/No indicator when the field is "occupied". Thanks for any help.
Raybaudi Posted February 14, 2009 Posted February 14, 2009 Hi formatting as Boolean a calculation field with calc: Lenght ( Field ) > Lenght ( Filter ( Field ; "blank, tab, carriage return and the like" ) )
K1200 Posted February 15, 2009 Author Posted February 15, 2009 I believe I understand what you mean. So the check would be: If (Length (Table::TextField) > Length (Filter(Table::TextField ; Char(9) & Char(13) & Char(32))) And then I would need to expand the character list to include any other non-printing codes that I encounter. Thanks for the response.
Recommended Posts
This topic is 5762 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