|
By kniskan - Friday, July 13, 2012
|
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 .
|
|
By genome - Friday, July 13, 2012
|
One way to replace spaces in fields with a blank entry is to use Find & Replace. e.g. Click Table Layout / Individuals.., then right click on a column header of a field that has space entries and choose Find & Replace... at the top. Then click the Pick button and select the entry with space(s) at the top and click Ok, finally click Replace All.Repeat this for all fields with blanks. If a field sometimes has one blank and sometimes two then repeat for each.
|
|
By kniskan - Friday, July 13, 2012
|
|
Thanks for the tip, it did the trick.
|
|