February 14, 200916 yr 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.
February 14, 200916 yr Hi formatting as Boolean a calculation field with calc: Lenght ( Field ) > Lenght ( Filter ( Field ; "blank, tab, carriage return and the like" ) )
February 15, 200916 yr Author 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.
Create an account or sign in to comment