June 7, 2009 at 8:59 am
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
June 7, 2009 at 10:24 am
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
June 9, 2009 at 4:54 am
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