Search found 150 matches

by quarlton
04 Nov 2021 14:20
Forum: General Usage
Topic: a few age related questions
Replies: 35
Views: 10684

Re: a few age related questions

Official response from CP

To: Dave Simpson

Sorry, it's not possible at the moment as the {age_range} does not have an equivalent built in function.



Ros

Family Historian Support
Calico Pie
by quarlton
03 Nov 2021 13:11
Forum: General Usage
Topic: a few age related questions
Replies: 35
Views: 10684

Re: a few age related questions

Many thanks for your reply Mike.

It does seem strange that {age range} exists for use in Sentence but not in query functions.

I've asked the question of Calico Pie - but I'm not holding my breath.

As I said, it was just something that made me curious.
by quarlton
03 Nov 2021 11:34
Forum: General Usage
Topic: a few age related questions
Replies: 35
Views: 10684

Re: a few age related questions

This is a question asked out of curiosity. When a new event is added to a person, FH adds an age in brackets. On occasion this is a dual age e.g. (46-47). I was idly wondering how FH arrived at these two values. Reading Lorna Craig's post above, I note that in Sentence there is the option to use {ag...
by quarlton
31 Oct 2021 15:31
Forum: General Usage
Topic: Tutorial on Queries
Replies: 60
Views: 27346

Re: Tutorial on Queries

Many thanks Mike, it worked perfectly.
by quarlton
31 Oct 2021 13:06
Forum: General Usage
Topic: Tutorial on Queries
Replies: 60
Views: 27346

Re: Tutorial on Queries

Hi I've been trying to adapt the INDI.~FATH>CENS[year=" . Year(%FACT.DATE%) . "].PLAC" example to use with a parameter. In this example: %INDI.CENS[year=1851]% the 1851 would be a parameter What I came up with was %INDI.CENS[year= . "Year(["Param"]) . "]"% %INDI.CENS[year= . "Year(["Param"]) . "]%" ...
by quarlton
24 Oct 2021 09:54
Forum: Plugin Technical Support & Development
Topic: Export Gedcom File plugin new features
Replies: 29
Views: 5559

Re: Export Gedcom File plugin new features

Thanks for the update Mike.
Just done a test run and it worked fine.
by quarlton
21 Oct 2021 14:26
Forum: General Usage
Topic: Parallels - Windows 11 - Family Historian
Replies: 9
Views: 2787

Parallels - Windows 11 - Family Historian

Just a quick heads-up for anyone using Parallels. I've just upgraded Windows 10 to Windows 11 following the guidance on the Parallels website. I used a separate Windows 10 install rather than my main install - just in case :-) All went according to plan - did have to use the 'AllowUpgrade.reg' featu...
by quarlton
12 Oct 2021 16:41
Forum: General Usage
Topic: Conditional Expressions in Queries
Replies: 5
Views: 1221

Re: Conditional Expressions in Queries

Mike you are brilliant😄
by quarlton
12 Oct 2021 16:00
Forum: General Usage
Topic: Conditional Expressions in Queries
Replies: 5
Views: 1221

Re: Conditional Expressions in Queries

Having got my columns working the way I want, what I would like to do is something similar or rows, but I have a feeling that this is going to be a definet NoNo. What I would like is to have two filters that use 'and' Exclude Unless %INDI.BIRT[1].DATE% is null and Parameter = 1900 Exclude Unless %IN...
by quarlton
12 Oct 2021 14:33
Forum: General Usage
Topic: Conditional Expressions in Queries
Replies: 5
Views: 1221

Re: Conditional Expressions in Queries

Thanks Mike

I've just tried it for the umpteenth time and it worked!

No idea what went wrong before.

As usual many thanks for your input.

Dave
by quarlton
12 Oct 2021 14:08
Forum: General Usage
Topic: Conditional Expressions in Queries
Replies: 5
Views: 1221

Conditional Expressions in Queries

Is it possible to incorporate a Parameter into a conditional expression? e.g. I have a Parameter called 'EnterYear' The value entered in 1920 What I want to do is do a conditional expression that displays different values depending on the Parameter value. e.g. =TextIf(["EnterYear"]=1920,"Success", "...
by quarlton
24 Sep 2021 10:13
Forum: Plugin Technical Support & Development
Topic: Export Gedcom File plugin new features
Replies: 29
Views: 5559

Re: Export Gedcom File plugin new features

Hi Mike I've just had to use the plugin with the 'Keep Media folders' option for the first time. My first thought was that it wasn't working as the progress bar wasn't showing, so I aborted it. Eventually I discovered that what was actually going on was that it was busy recreating the Media folder s...
by quarlton
12 Sep 2021 11:10
Forum: General Usage
Topic: FH V7.0.8.2
Replies: 13
Views: 3045

Re: FH V7.0.8.2

Many thanks - that worked.
by quarlton
12 Sep 2021 10:55
Forum: General Usage
Topic: FH V7.0.8.2
Replies: 13
Views: 3045

Re: FH V7.0.8.2

Is anyone else having issues downloading the upgrade? I've tried on 3 machines so far and in each case it just hangs at 'Downloading upgrade file' Two machines are running Windows 10 under Parallels and 1 using Virtual box All machines have Internet access and FH can see the Internet when looking at...
by quarlton
31 Aug 2021 10:37
Forum: General Usage
Topic: Is there support for the 'In' function in queries?
Replies: 2
Views: 997

Is there support for the 'In' function in queries?

Is there a way of using 'In' with a query? e.g. Pick up the country name for an event place using =TextPart(%_PLAC%,-1) to get the last element of the Place Assume that this returns "Australia" What I would like to test in the query is along the lines of this: Exclude if "Australia" is in (Australia...
by quarlton
19 Mar 2021 10:20
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Thanks Mike, I'll have a look at this morning.
by quarlton
19 Mar 2021 08:59
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Mike Thanks to your rewriting of the Tidy function, I believe that I can streamline the procedure a bit. Instead of using my function to test if a place name needs tidying, then using the Tidy function, I could simply call the Tidy function with each place name. Then if the result is changed from t...
by quarlton
17 Mar 2021 14:56
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Mike

The penny has dropped now with the Newton issue!

Oh well, at least the exercise has given my brain a workout.

Thanks for all your help.

Dave
by quarlton
17 Mar 2021 12:58
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Mike Thanks for the modified TIDY code, it works as promised. :) Looking at the Newton scenario it would seem that my approach does work. I created 4 Places: Newton ,, ,USA Newton,,,USA , Newton,,USA Newton, USA The first 3 report as being 'Malformed' and tidy to Newton, USA They also show as cla...
by quarlton
16 Mar 2021 15:57
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Mike Many thanks for checking that for me. No problem in waiting - I'm not going anywhere at present :) (1) Plugin Header - Fixed (2) Opening Message - Fixed (3) Place Tidy I'm having a little difficulty with this one - hence writing my own routine. If we look at the following example, it deals w...
by quarlton
12 Mar 2021 19:58
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Folks Opened, in wwd, an existing place - quotes are to show start & end 'Adelaide,South Australia, Australia' changed it to ' Adelaide,South Australia, Australia ' Clicked OK Opened it again to edit 'Adelaide,South Australia, Australia' FH has trimmed whitespace front and back Pretty conclusive ...
by quarlton
12 Mar 2021 18:15
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Tom

Just sitting down for dinner - will try and have a look later.

Can you clarify what is meant by www please?
by quarlton
12 Mar 2021 17:49
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Ron

On both v6.2 and v7
If I enter the Place for an event with a leading space, as soon as I move to another field you can see FH removing the leading space.
by quarlton
12 Mar 2021 17:22
Forum: Plugin Technical Support & Development
Topic: Find Duplicate Place Names
Replies: 33
Views: 9238

Re: Find Duplicate Place Names

Hi Ron

I haven't trapped for leading or trailing spaces because FH appears to handle them itself.
If you go to Tools and Choose work with Data, Places
Then edit an entry to add leading/trailing spaces, FH will ignore them.