I am looking for a Query Function which combines Address and Place for outputting to a CSV File.
Regards
Colin
* Combine Address & Place Query
-
ColinBeaver
- Diamond
- Posts: 67
- Joined: 05 Mar 2010 07:31
- Family Historian: V6.2
- tatewise
- Megastar
- Posts: 27082
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Combine Address & Place Query
Use the =Text() function.
E.g.
=Text( %FACT.ADDR% . %FACT.PLAC% )
or to insert comma & space between them:
=Text( %FACT.ADDR% . ", " . %FACT.PLAC% )
or if the comma & space are conditional on both Address & Place existing:
=Text( %FACT.ADDR% . TextIf( Exists(%FACT.ADDR%) and Exists(%FACT.PLAC%), ", ", "" ) . %FACT.PLAC% )
E.g.
=Text( %FACT.ADDR% . %FACT.PLAC% )
or to insert comma & space between them:
=Text( %FACT.ADDR% . ", " . %FACT.PLAC% )
or if the comma & space are conditional on both Address & Place existing:
=Text( %FACT.ADDR% . TextIf( Exists(%FACT.ADDR%) and Exists(%FACT.PLAC%), ", ", "" ) . %FACT.PLAC% )
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
ColinBeaver
- Diamond
- Posts: 67
- Joined: 05 Mar 2010 07:31
- Family Historian: V6.2
Re: Combine Address & Place Query
Thank you for the solution, it work perfectly.
As part of my project to show the locations of each branch of my ancestor's on Google Earth, I used the Plugin Map Life Fact. This version 3.7 ignore address field and only used the Place Field.
I then upgrade the plugin to 3.8 and now it cannot run.
I am currently running version 5 of Family Historian.
Any Thoughts
Thanks & Regards
Colin
As part of my project to show the locations of each branch of my ancestor's on Google Earth, I used the Plugin Map Life Fact. This version 3.7 ignore address field and only used the Place Field.
I then upgrade the plugin to 3.8 and now it cannot run.
I am currently running version 5 of Family Historian.
Any Thoughts
Thanks & Regards
Colin
- tatewise
- Megastar
- Posts: 27082
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Combine Address & Place Query
I answered that problem in Map Life Facts Will Not Run (13820)!
The default always has been to only plot Place fields but that is changed in the Set Preference Options tab.
The default always has been to only plot Place fields but that is changed in the Set Preference Options tab.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry