How to remove decimal point in DataStage?

Question

I would like to remove the decimal point from the column.

For example, D21.3 would become D213

Someone help me, please.

score 0 · Answer 1 · answered Dec 21 '22 at 07:15

0

If you are using DataStage 9.1 or above, try:

Ereplace(ColumnName, ".", "")

answered Dec 21 '22 at 07:15

K H A N

Thank you, Khan, It is working now. How to do the same transformation in Netezza? – Krishna Dec 21 '22 at 11:18

score 0 · Answer 2 · answered Dec 21 '22 at 14:32

0

In Netezza

=> select translate('D21.3','.','');
 TRANSLATE
-----------
 D213

answered Dec 21 '22 at 14:32

Mark F

2 Answers2