This function is used to extract a value from a list. In the first example, the data element contains a number (an integer) which is used to get an item from a list, where the list is coded in the fillpoint itself: «GetListItem(BondNumber,’First,Second,Third,Fourth,Fifth,Big’,’,’)» If the value of the ‘BondNumber’ data
This function converts spaces to “hard” or non-breaking spaces. When Word performs word-wrapping at the end of a line, a non-breaking space will not appear at the end of a line but will cause the characters on either side of it to be on the same line. «HardSpace(FormatNumber(Amount,“#,#0.00”,“ZA”))» If the
Dates can be formatted according to patterns defined in the fillpoints. Command structure: «FormatDate(Date_of_Engagement,”yyyy-MM-dd”)» «FormatDate(Date_of_Signature,”MMM d yyyy”)» «FormatDate(Date_of_Dismissal,”d MMMM, yyyy”)» «FormatDate(Date_of_Signature,”MMMM o yyyy”)» «FormatDate(Date_of_Signature,”dddd MMMM o yyyy”)» These examples would result in something like, respectively: 2019-02-07 Feb 7 2019 7 February, 2019 February 7th 2019 Thursday February 7th
Max calculates the maximum of two values: The maximum of «Number1» and 100.1 is «Max(Number1,100.1)». Min calculates the minimum of two values: The minimum of «Number1» and 100.1 is «Min(Number1,100.1)».
Now The Now function inserts the current date and/or time into the document. It can be formatted in the same way as for FormatDate. «Now(“d MMMM, yyyy”)» yields ‘4 November, 2010’ «Now(“MMMM o yyyy”)» yields ‘November 4th 2010’ «Now(“yyyy/MM/dd HH:mm:ss.fff”)» yields ‘2011/04/14 17:05:23.010’ which is exactly the same as «Now()»
NumberPhrase is used to convert a number to words, in several different languages. Command structure: «NumberPhrase(Area,”,’leave’)» Examples of usage: «NumberPhrase(Area,”en-us”,”ToUpper”)» Suppose a data element with name ‘Area’ has a value 1234:This would yield “ONE THOUSAND TWO HUNDRED THIRTY-FOUR” Parameters: Languages supported are ‘en’ (US English, the default), ‘fr’ (French), ‘de’
Replace is used to replace all occurrences of one string in a source string with another string: «Replace(Address,”Ave.”,”Avenue”)» “123 Long Ave., Cape Town” becomes “123 Long Avenue, Cape Town”
The result of this function would typically not be included directly in the merged document, but would be used in a conditional, such as: If «When(StartsWithVowel(Fruit),an,a)» «Fruit» is ripe it tastes better than if it is rotten. The function assumes that ‘a’, ‘e’, ‘i’, ‘o’ and ‘u’ (and their uppercase
The TableLookup function enables the calculation of an amount from a table. Typically this is used with tax tables, or other tables of tariffs. The normal tax calculation for South Africa for the 2008/09 tax year is based on this table (reproduced from the South African Revenue Services web site):
Regardless of the case of the value entered into the interview or imported from a database, that value can be converted using the following commands into a different case on the assembled document: ToUpper This will place the UPPER CASE value of the data into the document: «ToUpper(FullName)» “Fred
This function is used to gain access to the user name with which the person running the template logged on to Windows The person running this template is logged on to Windows with the user name: «WindowsLogonUser()». It is often used in conjunction with the SetSavedDocumentFolder and SetSavedDocumentFileName commands in
901 S MoPac Expressway, Building 1, Suite #300, PMB 300127, Austin, TX, 78746, USA
85 Tottenham Court Road, London, W1T 4 TQ, UK
35 Anderson Road North, Cape Town, 7550, Western Cape, South Africa
Copyright ©2023 XpressDox. All Rights Reserved. | Website By Hello Fascination
