ToString (Any data, String format)

Name	ToString
Syntax	ToString (Any data. String format)
Purpose	To convert a value into a string with a given format.
Description	Returns string representation of the specified value. Returns null if value is null or format is invalid.
Return Type	String
Parameters	Data [System.Object] Format [System.String] – Output format of the value. This method accepts any Microsoft.Net format specification

Example

We have an Orders dataset with a Freight field.

In this example we will attempt to convert the real values in this field to string values representing currency. We will map the Freight field to the data field of the function transformation object.

We will also use a Variables object to specify an acceptable Microsoft.Net format for currency.

Where,

Format = C

In the output window, you can see that the provided data from the Freight field has been converted to a string representing currency.