Formatting

PropertyExpressionDescription
Formatting
Chr(index)
Returns a single ASCII text character, represented by the character index. For example, the following expression returns "A": Chr(65) For a full list of ASCII character indexes, Google ‘ASCII’.
Formatting
Format(value, format)
Returns value formatted according to the format specified. The following data types can be formatted: Date DateTime Time Number Boolean The format parameter contains either a standard format or a custom format. The available formats are too numerous to list here, but they follow the Microsoft MSDN formatting rules. References for the various data types can be found here: Date and DateTime – Standard Formats Date and DateTime – Custom Formats Time – Standard Formats Time – Custom Formats Number – Standard Formats Number – Custom Formats Boolean: Formatting a Boolean value is simple – just provide either the positive or negative aspect you wish to use as a template. For example, the format "y" will result in value being formatted as either "y" or "n". The valid Boolean formats are: 1, 0, true, false, t, f, yes, no, y, n
Formatting
FromJSON(json, xpath)
This function is similar to the FromXML function below, but it queries a JSON document instead. Under the covers, Conductor converts your JSON document into XML and then uses XPath to query it. Please see FromXML, below, for more information on this.
Formatting
FromXML(xml, xpath)
This function executes an XPath query against the XML document and returns the value specified in the xpath query. XPath is a standard language for referring to specific information within XML documents. It can be used for many things, but here it must be used to locate either one tag value or attribute value within the XML document. If a value is found by the XPath query it is returned by this function. If the query fails to locate a value or is malformed, an error will occur, explaining the problem. Describing how to use XPath is beyond the scope of this document, but if you Google ‘xpath’ you should find information. Failing that, try this introduction by W3C
Formatting
ToTemplate(template)
Merges row and system data using a marked up template and returns the resulting formatted information. Template is any piece of text, but it may contain special tags which will be replaced with real data when the expression is executed. These special tags look like this: {data:PhoneNumber} {system:SourceDataStoreName} For the valid options for each, see the description for the Data and System functions below. For example, consider this template: ToTemplate("Name: {data:LastName}, {data:FirstName}. Age: {data:Age}") Assuming the row data contains all three columns mentioned in the template parameter, this function call might return something like this: "Name: Smith, Jane. Age: 47"