Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    30

    Unanswered: Translate Non Printing Characters to spaces

    Hi, Im having a problem which I would think we be straight-forward but is not... I have loaded from SQL statements from Unix into an Oracle table ( line by line ), and am trying to then convert any instance of a TAB into a space...

    so I'm trying :

    REPLACE(sql_column, '\t', ' ') but its not working ??

    Thanks,
    Adam

    -----------------------

    I would like to expand this question to include converting any non-printing characters that can ever be found in a VARCHAR2 column ( basically the characters that display as a little box when using a front-end Oracle utility ), such as a carriage return, form-feed... Thanks
    Last edited by arnzie; 03-24-04 at 01:41.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Try using the ascii value for tab, rather than the \t.

    For example...

    select replace('ABC',chr(65),chr(66)) from dual

    IIRC the ascii value for tab is 8.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

Posting Permissions

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