Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 bcp import manipulate data

Author  Topic 

dgaylor
Yak Posting Veteran

54 Posts

Posted - 2003-04-18 : 01:13:59
I am using bcp to import a flat text file and am using a format file. I would like to know if it is possible to strip out single quotation marks while the data is being loaded rather than doing it afterwards. Thanks.

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-04-18 : 03:45:23
Check out here
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=24734

I have given a format file to remove double quotes.
HTH

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-04-18 : 08:57:04
Thank you Sekar, I was looking for something like that.

Go to Top of Page
   

- Advertisement -