Topic: SQL Server. bcp. A formatting file. Inverted commas that is is not present... Whether it is possible to win somehow?
Kind time of days!
SQL Server 2016. I create a formatting file fmt such line
bcp Base_S.dbo.tbl_S format nul-c-t,-f C:\TC\S.fmt-T
Field delimiter the comma appears, but in one of fields there is a comma in field value, therefore field value is selected in inverted commas. That such to accept I the file fmt corrected hands adding in a separator ", \" "and" \",". All worked well, did not come yet to hands csv a file in which in this field that is inverted commas they are not present... It is possible to process such situation somehow?
Here a screen - http://prntscr.com/gufqay
In advance I thank for the help.