Page 1 of 1

Combine Address & Place Query

Posted: 19 May 2016 16:39
by ColinBeaver
I am looking for a Query Function which combines Address and Place for outputting to a CSV File.

Regards
Colin

Re: Combine Address & Place Query

Posted: 19 May 2016 16:48
by tatewise
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% )

Re: Combine Address & Place Query

Posted: 20 May 2016 15:38
by ColinBeaver
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

Re: Combine Address & Place Query

Posted: 20 May 2016 15:52
by tatewise
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.