Home Dashboard Directory Help
Search

Exporting CSV cannot handle commas/quotes in strings! by gift_of_seasons


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


4
0
Sign in
to vote
Type: Bug
ID: 636080
Opened: 1/14/2011 12:50:09 AM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

When saving 'select' result to csv file, SSMS does not handle commas/quotes in string values! It's bad.
Details
Sign in to post a comment.
Posted by gift_of_seasons on 4/19/2011 at 6:05 AM
It's amazing... It works, but these options should be enabled by default.
Posted by Microsoft on 4/19/2011 at 3:43 AM
Hi

Greetings from the SQL Server Manageability team.

Thanks for writing in to Microsoft. We greatly value your feedback.

We have an option in SSMS which can take care of the issue reported by you, when data contains comma/quotes.

Right Click on TSQL Editor -> Query Options -> Results and check the option
"Quote strings containing list separators when saving .csv results".

or

Tools -> Options -> Query Results -> SQL Server -> Result to Grid
check the option "Quote strings containing list separators when saving .csv results"
(Effect will take place on TSQL editors that are opened after this option is selected)

In case you some other concern, feel free to reactivate this defect.

Thanks again for providing feedback and making SQL Server the greatest Database server.

Regards,
Kamal
Posted by gift_of_seasons on 3/24/2011 at 1:11 AM
If you cannot fix this, please remove this feature. Without correct handling of commas and quotes, it's almost useless to export CSV!
Sign in to post a workaround.