How to remove comma from numeric field

[csc.datastage]

Hi ,

My input data is as follows:

Col A ( Number)
1,002.03
123,002.34
1,234,002.96

How do I remove comma (,) from numbers in datastage.
I know I can remove it using Unix but can it be done using Datastage?
My desired output is:


1002.03
123002.34
1234002.96

Thanks for all your help!

[DSguru2B]

Use the CONVERT() function.

Code: Select all

CONVERT(",","",in.numericfield)

[ray.wurlod]

Code: Select all

Iconv(InLink.TheNumber, "MD2")

is an alternative; it has the advantage that it will remove currency symbols as well.

[chulett]

I'm curious as to the 'why' of this... is the target of your 'desired output' a database table for instance? Flat file? Something else entirely?

[csc.datastage]

I'm curious as to the 'why' of this... is the target of your 'desired output' a database table for instance? Flat file? Something else entirely?

Target is a flat file with which We need to perform mathematical calculations using datastage.

Thanks for all your help!

[sharantheboss]

Hi,

Use the function Ereplace (string, substring, replacement )
In your case it would be Ereplace(Col A,',','')

Regards
Boss :D

Hi ,

My input data is as follows:

Col A ( Number)
1,002.03
123,002.34
1,234,002.96

How do I remove comma (,) from numbers in datastage.
I know I can remove it using Unix but can it be done using Datastage?
My desired output is:


1002.03
123002.34
1234002.96

Thanks for all your help!

[ray.wurlod]

Ereplace() is the least efficient of the three suggestions offered.