Exporting Select statement values into csv with escape characters
-
hi all, I am exporting record-set of select statement into a csv, but when I am doing it, if the fields already have values with , and then that comma is going into the csv as it is, and because of it the import is becoming tough, I want to have an escape for those comma which are coming from the field values. Any help would be grateful, thanks in advance friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
hi all, I am exporting record-set of select statement into a csv, but when I am doing it, if the fields already have values with , and then that comma is going into the csv as it is, and because of it the import is becoming tough, I want to have an escape for those comma which are coming from the field values. Any help would be grateful, thanks in advance friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
You could use the BCP command with the -t option. See [bcp Utility](https://msdn.microsoft.com/nl-be/library/ms162802(v=sql.120).aspx) And there is a lot of other ways. Just google for something like MSSQL import into .csv