BCP or Bulk Insert file containing quoted strings, embedded delimiters

28 views
Skip to first unread message

Robert Tuck

unread,
Dec 10, 2003, 3:08:09 PM12/10/03
to
Hi,
Anyone know if it is possible to use Bulk Insert or BCP commands to
import a text file into SQL 2000 which contains single or double quotes
around string values, and tell it to ignore any embedded column delimiters?

1 Row Example:

9382,"Test, Description",349.00,"N","Joe Smith"

(Needs to ignore the comma in "Test, Description" and possibly remove the
double quotes.)

Thanks,
Robert


lindawie

unread,
Dec 10, 2003, 3:18:10 PM12/10/03
to
Robert,

You can use a bcp format file for this. Some examples:

http://www.google.com/groups?q=+first_quote+author:lindawie


Linda

Robert Tuck

unread,
Dec 10, 2003, 3:27:00 PM12/10/03
to
Dang, that was fast! I'll check it out. Thanks, Lindawie!


"lindawie" <lind...@my-deja.com> wrote in message
news:%23yHIJr1...@TK2MSFTNGP11.phx.gbl...

Code The Crab

unread,
Aug 28, 2020, 7:38:03 AM8/28/20
to
seems you were successfull in doing the above operation can you reshare the link or copy the solution over here.
The above link is expired.

Thankyou in Advance

Michael Cole

unread,
Aug 31, 2020, 6:15:37 AM8/31/20
to
Code The Crab presented the following explanation :
Possibly because the message itself was from 2003, which is almost 17
years ago. As such, the chance of the OP actually reading this
response is rather remote.
Reply all
Reply to author
Forward
0 new messages