Save as in Toad

  • i am trying to save the output of a query to a delimted text file with comma as delimter.

    if a column contains a column with column (For example John,smith) John goes to one column and smith to other column

    how do i avoid and make it as one column.

    Please let me know

  • I.m using SQL2008 so the exact option may differ to mine.

    In SQL Management Studio from the tools/options menu look for the "query results" branch on the left hand side.

    In results to text the "Output format" has a number of options which includes TAB delimited and also has the ability to specify a custom delimiter

  • Hi,

    Are you using Toad for SQL Server? I use the Oracle version (9.7.2), so I don't know if this will be applicable.

    Do you have the 'Save Grid Contents' dialog on screen, Export Format: Delimited Text?

    Go to String Quoting and pick 'Double Quote String Columns'. Most import tools (including Excel and SQL*Loader) are happy with column values enclosed in double quotes.

    Alternatively, you can could change the Delimiter (next option) if your import tool is happy with that . . . I alwasy use ^ - never seen it in data yet . . . 🙂

    HTH

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply