Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    4

    Unanswered: Tab-delimited format

    Hello all,
    What is the syntax for tab-delimited? I use ||'~'|| for tilde-delimited, but I dont know how to change it to tab-delimited.

    Thanks,
    lynd.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    set tab on
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2004
    Posts
    4
    how to set the tab on? :?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Concatenate field with a function that returns TAB. In Oracle, that would be something like this:

    select field1 || chr(9) || field2 || chr(9) ... from your_table;

Posting Permissions

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