top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to convert string into number using expression transformation in informatica? [CLOSED]

+1 vote

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

how can i get this same data with '$' symbol in target by using expression transformation in informatica?

anyone help me please, thanks in advance.

posted May 20, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes


or if it's always the first character and you don't have to worry about spaces


answer May 21, 2014 by Shweta Singh
I think requirement is different, as per the requirement number should be loaded along with '$'.
As per your logic '$' sign will be removed and only number will be processed.
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.