ToString (Any data, String format)

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.

© Copyright 2023, Astera Software