Additional Functions

Miscellaneous functions for use in Keyfax Databox Expressions.

Transform

This should only be called on a Databox containing XML data and applies a pre-defined transformation to generate a display-friendly presentation of the XML data.

Currently there is only 1 transformation designed to work with the XML returned from the Services System Values Databox.

Transform('Transform/Services.xsl') 

Use this with a 'Services' System Values Databox to format details of all Services recorded in a script into an HTML table for inclusion in an email.

This can handle an additional Standard Minute Value (SMV) column if appropriate.

IMPORTANT Any changes in this area must be configured by Omfax Systems to ensure the SMV is included in the Services export (e.g. using Services2SMV template), the SMV heading text is defined in TransformServicesStandardMinuteValue and this element is included in TransformServicesElements in the language text.

Date Functions

The following operate independently of the Databox value. They can only be used as a parameter to another function or after an operator.

Function	Sample Expression	DataBox Value	Result	Comments
Now	&Format(Now,”dd MMM yyyy – HH:mm”)		01 April 2010 – 09:00	Returns the present Date and Time
Today	&Format(Today, “MMM yyyy”)		April 2010	Returns the present Date

ds (Datasource)

The ds expression function is useful for when you want to use the value of a databox multiple times in one expression. Please see Ds.

Numeric Functions

Function	Sample Expression	DataBox Value	Result	Comments
%	12 + 10%		13.20	Add n% of original value
Rnd	Number + Rnd format("F4")	1	0.8946	Returns a random number between 0 and 1

Text Functions

Function	Sample Expression	Databox Value	Result
ChCR	Replace(", ", ChCR)	"Hello, world"	Hello world	The example replaces a comma followed by a space with a Carriage Return character
ChCRLF	Replace(", ", ChCRLF)	"line 1, line 2, line 3	line 1 line 2 line 3	Replace comma and space with Carriage Return and Line Feed characters
ChLF	Replace(", ", ChLF)	"Hello, world"	Hello world	The example replaces a comma followed by a space with a Line Feed character
ds	Replace(ds, 'Hello ') + ds	"world"	Hello world	This replaces the initial value with a prefix (‘Hello’) and then appends the initial value. ‘ds’ represents the original DataBox Value.
HtmlLineBreak	Replace(",", HtmlLineBreak)	"line 1, line 2, line 3	line1<br/> line2<br/> line3	Html "<br/>" text