Transfering data from VARCHAR field to a NUMBER field

[yaminids]

Hello friends,

I am getting the following error when I tried to transfer data from a VARCHAR field to NUMBER field
"ORA-01722: invalid number"

Is it possibe to convert the data (similar to to_number() function)
using a particular function in DataStage?

Any help would be highly appreciated
Yamini

[kcbland]

If it is truly a number stored in a varchar column, there's nothing to do in Server. It's obvious you are not loading a number, but something else. Consider removing any symbols that are used in string representations of numbers such as the following:

$ , % # /