FORMAT

Returns a string value formatted with the specified format. Can be used for formatting DateTime and number values as strings.

Syntax

string FORMAT(string format, params object[] args)

##Inputs | Object | Data Type | Description | |---|---|---| | format | String | A template string. | | object[] | String | List of string values to insert into the template. |

Example

FORMAT("Value1: {0}, Value2: {2}", Value1, Value2)

or

FORMAT("{0}, {1}", LastName, FirstName)

Will return a list of names in the format LastName, FirstName.

or

FORMAT("{0} is a beautiful city in {1}", CityName, StateName)

Will return "[CityName] is a beautiful city in [StateName]" pulling the CityName from the CityName column and the StateName from the StateName column.

Please also refer to the MSDN page String.Format Method from which this function is based upon.