Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

How to test for printable text?


This topic is 5762 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

Hi

formatting as Boolean a calculation field with calc:

Lenght ( Field ) > Lenght ( Filter ( Field ; "blank, tab, carriage return and the like" ) )

Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.