The NEW XpressDox Version 14 is now available!

Edit Content
Click on the Edit Content button to edit/add the content.

April 14, 2011

The GetListItem Function

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

Read More »

The HardSpace Command

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

Read More »

FormatDate

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

Read More »

The Max and Min Functions

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)».

Read More »

The Now and Today Functions

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()»

Read More »

NumberPhrase

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’

Read More »

The Replace Function

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”

Read More »

The StartsWithVowel Function

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

Read More »

The TableLookup Function

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):

Read More »

Change the Case of a Value

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

Read More »

The WindowsLogonUser Function

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

Read More »