Be aware that =GetLabelledText(... NOTE2 .....) will only pick up the first
occurrence of the NOTE2 field (aside: why is it NOTE2? I cannot find any
reference to this notation, other than in examples, in the Help manual?)
For example, I have a few records with more than one NOTE attached to a DEAT
event. In most cases the label (say "Registrar:") occurs in the first NOTE,
but in some it is in a second or subsequent NOTE fields. In the latter
cases, the query doesn't extract the required text, even though it does
It does seem to support ... NOTE2, NOTE2, NOTE2 etc, listing each as a
separate column in the result set. However, the perfectly sensible
NOTE2[1+] looping notation appears to pick up the first occurrences only!!
This is another example of FH's inconsistency; Why not allow the looping
index notation (e.g. NOTE2[1+]) in all situations where a field/record can
be repeated, to cater for this perfectly legal situation?
Also, note that =GetLabelledText() picks up ALL text from the label to the
end of the paragraph. So, for example, if you're searching for
"Registered:", and your NOTE contains "Registered: Anytown, Registrar:
AnyPerson" it will output the entire string, not just "Anytown". The
way round this is to ensure your NOTE has each Label on a new line.
Perhaps =GetLabelledText() could be modified to extract text up to the end
of the paragraph or the next label, whichever came first (a Label defined as
a sequence of characters preceded by a space and ended by a ":", for
[mailto:email@example.com] On Behalf Of Jane
Sent: Monday, January 28, 2008 7:45 PM
Subject: Re: [FHU] Event Attributes
Although you can not comment out lines you could always prompt for the
Label, for example
would allow you to select the entered labelled text from a Local Note and
the same line used on a condition could exclude all the null values.
You would still need to add all the possible events you have labelled text
on, but it would keep the volumes down and you could use the containstext
function to look on all records for the label on all fields, but I don't
think there is a way currently to extract the following text once the label
On 28/01/2008, Graham Chamberlain <agc(a)katiandgraham.com> wrote:
It would be useful to have a generic query (rather than a set of
individual specific queries) with a variety of "GetLabelledText"
expressions and "comment out" those which didn't apply for a
particular search. Is there such a way to "comment out" expressions?
Family Historian Users List Moderator
Family Historian User Group Site Web Master http://www.fhug.org.uk
To unsubscribe from the list, please send an email to
FAMILY-HISTORIAN-USERS-request(a)rootsweb.com with the word 'unsubscribe'
without the quotes in the subject and the body of the message
No virus found in this incoming message.
Scanned by AVG V7
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.13/1246 - Release Date: 27/01/2008