I have this in the query that I use for my records window:
=Relationship(FileRoot(),,TEXT,1)
is there a way to convert
1st cousin 7 times removed
to
1c7r
or is there a short form like there is for dates and places?
* modify output on relationship to root
-
BevSmallwood
- Diamond
- Posts: 59
- Joined: 14 Jul 2022 18:01
- Family Historian: V7
- Location: Wisconsin, USA
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: modify output on relationship to root
I guess you mean a Column Expression in the Records Window rather than a Query which is something rather different but would have exactly the same difficulty.
The short answer is "no".
It might be possible with a very complex expression but it has to cope with a great many possible relationships.
e.g.
1st cousin once-removed
1st cousin once-removed's wife
1st cousin once-removed's partner
1st cousin twice removed
1st cousin twice removed's wife
1st cousin twice removed's partner
1st cousin 3 times removed
1st cousin 3 times removed's wife
1st cousin 3 times removed's partner
2nd cousin once removed
2nd cousin once removed's wife
2nd cousin once removed's partner
3rd cousin
It would be easier if a Plugin script could be invoked by the Expression to perform the conversion.
But that needs Wish List Ref 547 Run Plugins via Expressions to be implemented so please Vote for it.
This is another request that has been pending for nearly 7 years.
The short answer is "no".
It might be possible with a very complex expression but it has to cope with a great many possible relationships.
e.g.
1st cousin once-removed
1st cousin once-removed's wife
1st cousin once-removed's partner
1st cousin twice removed
1st cousin twice removed's wife
1st cousin twice removed's partner
1st cousin 3 times removed
1st cousin 3 times removed's wife
1st cousin 3 times removed's partner
2nd cousin once removed
2nd cousin once removed's wife
2nd cousin once removed's partner
3rd cousin
It would be easier if a Plugin script could be invoked by the Expression to perform the conversion.
But that needs Wish List Ref 547 Run Plugins via Expressions to be implemented so please Vote for it.
This is another request that has been pending for nearly 7 years.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
-
BevSmallwood
- Diamond
- Posts: 59
- Joined: 14 Jul 2022 18:01
- Family Historian: V7
- Location: Wisconsin, USA
Re: modify output on relationship to root
Thank you. I've voted on the plugin feature.
I was hoping there was a setting already in place that I wasn't aware of....
I was hoping there was a setting already in place that I wasn't aware of....