Functions (all)

GetLabelledText

Function Name:

GetLabelledText

Description:

The function retrieves a section of text from a specified long text field (e.g. a note or address field). The required portion of text is identified by a short text label that is passed as a parameter to the function.The function will search for a paragraph that begins with the specified label.  For example, if you called the function using the label "Confirmed:", the function would search the specified long text field for a paragraph beginning with this label. If found, it would return the text that came immediately after that label (up to the end of the paragraph).

Note: paragraphs within tables (in rich text notes) are not searched or matched by this function.

Minimum FH Version:

3

No. of Parameters:

2

Return Type:

Text

Parameter 1:

A reference to a long text field (e.g. a note or address field). A long text field is one that is displayed, or can be displayed, on more than one line.

Parameter 2:

The label to search for.

Examples:

=GetLabelledText(%INDI.BIRT.NOTE2%,"Confirmed:")

This example will return all text following the label 'Confirmed:' in a paragraph beginning with that label in the specified long text field.