Number Format

dataservices job design
1

Hi,

Can any one fine me a way to to this?

I have a CSV file which contains a value like ($7,288.90) or $7,288.90.
I need to remove these excel formats and load as decimal number like
-7,288.90 or $7,288.90.

I just tried chainging decimal(10,2) in the source file format, but I got an error Cannot convert data <$173939.29> into type . Context: Column <Column_name>"

I can do this by ifthenelse and replace_subtr multiple times. But is there any command available in BODI to this directly.

I appreciate your inputs.

Thanks,
Sri.

catchme (BOB member since 2009-08-24)

2

well,

If you don’t want to manipulate those string using DI function, the only other way I can see is at the Source file itself, if its not that a big deal!

data_guy :us: (BOB member since 2006-08-19)