Thread: Informatica

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    3
    Rep Power
    0

    Informatica


    How to convert string into number using expression transformation in informatica?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    http://www.bispsolutions.com/web/home.php


    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.

    O_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))

IMN logo majestic logo threadwatch logo seochat tools logo