Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    49

    Unanswered: Parsering a varchar2 with 'tab'

    hi everybody,
    i have to tokenize a varchar2 to put single words in a table. words are separated by 'tab' character.
    i can get single words when the separator is a 'normal' character using the following code:
    INSTR(myString,'*',1,1);

    where the separator is '*'. but how can i do when the separator is a 'tab'???

    Thank you very much!!!

    Matte

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

    select INSTR('Hello'||chr(9)||' World',chr( 9 )) from dual

    HTH
    Bill

Posting Permissions

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