Skip navigation
Contact Us
3906 Views 11 Replies Latest reply: Apr 3, 2014 3:11 PM by Swetha c RSS
lavan kumar Apprentice 169 posts since
Apr 13, 2011
Currently Being Moderated

Feb 24, 2012 6:42 AM

How to remove commas in a column in informatica

Hi Folks,

 

 

Here my input data is like this coming as string datatype

 

Source_1_col

1,000,000.00
1,270,520.64
7,737.00
-7,737.00
-91,171.00
-79,294.00
-126,858.00
-379,086.42
-487,462.00
-755,537.12
-914,669.00

 

i need to remove commas in the data and i need out put like

1000000.00
1270520.64
7737.00
-7737.00
-91171.00
-79294.00
-126858.00
-379086.42
-487462.00
-755537.12

TO_decimal

 

(REPLACECHR(1,NetEntered,',',NULL)

)

but it is not coming populated in to target which is with '-' negative sign in row data

please any one tell me the correct expression what to write in the expr transfmn

 

Thanks in Advance

Lavan

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points