GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum


Home » GenoPro » Report Generator » Trim accidental spaces


Trim accidental spaces

Click to view RSS...
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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 Smile


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:
genome
Posted Friday, July 13, 2012 - Post #30365
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1
Last Login: 8 hours ago
Posts: 3,347, Visits: 25,658
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.

'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
kniskan
Posted Friday, July 13, 2012 - Post #30367
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Customers

Last Login: Sunday, October 16, 2016
Posts: 5, Visits: 35
Thanks for the tip, it did the trick.


Similar Topics

Click to view RSS...
Expand / Collapse

Reading This Topic

Expand / Collapse


Powered By InstantForum.NET 2010-3-x © 2024
Execution: 0.016. 6 queries. Compression Disabled.