top button
Flag Notify
Site Registration

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

+1 vote
327 views

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

TO_NUMBER(SUBSTR(AMOUNT,INSTR(AMOUNT,'$')+1,LENGTH(AMOUNT)-1))

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

TO_NUMBER(SUBSTR(AMOUNT,2,LENGTH(AMOUNT)-1))

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.
...