Get Data Moving 1
Results 1 to 3 of 3

Thread: SQL function "replace" in attunity

  1. #1
    CedrikBoussier is offline Junior Member
    Join Date
    Apr 2010
    Age
    36
    Posts
    7
    Rep Power
    0

    SQL function "replace" in attunity

    Hi,

    Is there an attunity equivalent to the sqlplus "replace" command ?
    For instance, we'd like to delete the carriage return/line feed character, tabulations, etc.

    for instance : something equivalent to that :
    Select REPLACE('texte', 'e', ' ') from dual;
    => "t xt "
    Select REPLACE(REPLACE('texte', 'e', ' '), 't', 'T') from dual;
    => "T xT "


    I've read the attunity doc AIS_530_User_Guide_and_Reference.pdf without finding any equivalence$




    Thanks in advance
    Cedrik

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Cedrik,

    Unfortunately Attunity Connect server doesn't support an equevalent SQL function to the Oracle REPLACE function.

    You may write a program that reads the field and updates it's data.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    CedrikBoussier is offline Junior Member
    Join Date
    Apr 2010
    Age
    36
    Posts
    7
    Rep Power
    0
    Thanks for your quick reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •