formulamerge
formulamerge
TEMPLATE
,
RESULT

The formulamerge statement merges data into a template.

Parameters

This statement has two parameters:

template – Text of template.

result – Output text (each formula has been replaced by its value).

Description

This statement merges data into a template. Within the template you can place formulas inside { and } characters.

This example assumes that the database has fields named Name, City and State (or that there are variables with these names).

    local Letter
    formulamerge "Dear {Name},"+cr()+cr()+
        "I am planning a visit to you in {sandwich("",City,", ")+State} next week.",Letter

The end result will be in the Letter variable, and will look something like this:

    Dear John Watson,

    I am planning a visit to you in San Francisco, CA next week.

If there is an error in the template the result will be:

    FormulaMerge Error “error message” Template “template”.

See Also

- makemergeformula -- makes a formula from a template.
- makemergeformula( -- builds a formula from an “auto-wrap" style merge template.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.