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.

© Copyright 2023, Astera Software