Text To Number

DESCRIPTION

Converts a text string to a numeric field.

Refer to Notes on Conversions for more details on how Data Prep Studio converts text to numbers.

INPUT/Output DATA TYPE

Input	Output
text	number

 

example

In this example, Amount is the original column and Amount** shows the converted values.