GenoPro Support Forum

Home Search Tags Who's On

Welcome Guest ( Login | Register )

Trim accidental spaces

Author	When a field entry consist only of blank spaces, how to skip it in report?
kniskan	Posted Friday, July 13, 2012 - Post #30364
Forum Newbie Customers Last Login: Sunday, October 16, 2016 Posts: 5, Visits: 35	I am helping my father in his project. He has almost 3000 entries and I just noticed that for some unknown reason, he has while putting in information entered only blank (space) to some fields. This now generates "bad" reports as the code thinks that there is something there - if only the field would be completely empty I would not have any issues. Is there a simple way somehow to trim/remove the leading spaces? It's not very convenient to check manually all the fields in those 3000 entries, so please help Example. Person's name is John Doe. Father is Jack Doe but mother is unkown and thus should be left out, but while entering the input data, space was pressed from the keyboard and thus the field has data - " ". While generating report, I thus get: John Doe's father is Jack Doe and mother is . Tags: Trim