*Columnised Place report

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
gsward
Platinum
Posts: 48
Joined: 11 Mar 2011 14:47
Family Historian: V6

Columnised Place report

Postby gsward » 07 Feb 2019 16:40

To use the Rearrange Address and Place Parts plugin it seems first I need to be able to select some of the places. Ideally, I would like to run a query to separate the place elements (i.e. the comma-separated parts) in a columnar report that can be sorted to group the misaligned places.

Does that query exist? Or how do I define the columns?

Graham

User avatar
Jane
Site Admin
Posts: 7416
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Columnised Place report

Postby Jane » 07 Feb 2019 16:52

If you are confident with Queries you can use the TextPart function to split the place name in to columns.

There are detailed examples in the Help for the Function.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."

User avatar
tatewise
Megastar
Posts: 15203
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Columnised Place report

Postby tatewise » 07 Feb 2019 17:02

May I say you are posing a question without defining your objectives.
Depending on what you want to achieve, and the state of your Place names, there may be easier ways.
Tell us what you want to achieve, and the problems you perceive in your Place names.
i.e. You don't have the same number of comma separated parts in all Place names.
Have you looked at what is possible with Tools > Work with Data > Places?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

gsward
Platinum
Posts: 48
Joined: 11 Mar 2011 14:47
Family Historian: V6

Re: Columnised Place report

Postby gsward » 07 Feb 2019 17:10

Yes, I have varying numbers of parts. A country, for example, is position 2, 3 or 4.

The issue with "Work with Data" - "Places" is I cannot get that selection into the Plugin.

gsward
Platinum
Posts: 48
Joined: 11 Mar 2011 14:47
Family Historian: V6

Re: Columnised Place report

Postby gsward » 07 Feb 2019 17:17

Jane, TextPart works a dream.

e.g.

Heading: Column 2
Expression: =TextPart(%_PLAC%,2,1,STD)

Thanks.

User avatar
tatewise
Megastar
Posts: 15203
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Columnised Place report

Postby tatewise » 07 Feb 2019 18:13

If there are not too many then Tools > Work with Data > Places can edit the Place part columns.

In the Plugin on the Input Filter tab you can choose which Place names to work on.
I understand that may be a little awkward, but by using the Ctrl and Shft keys in the usual way as explained in the Help & Advice you can select any combination.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry


Return to “General Usage”

Who is online

Users browsing this forum: Russell and 15 guests