X-Received: by 2002:aed:3b41:: with SMTP id q1mr1141526qte.190.1598614680536; Fri, 28 Aug 2020 04:38:00 -0700 (PDT) X-Received: by 2002:a05:6902:6b1:: with SMTP id j17mr1733807ybt.238.1598614680259; Fri, 28 Aug 2020 04:38:00 -0700 (PDT) Path: csiph.com!aioe.org!peer02.ams4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail Newsgroups: microsoft.public.sqlserver.programming Date: Fri, 28 Aug 2020 04:37:59 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: google-groups.googlegroups.com; posting-host=132.154.93.228; posting-account=Q-Px5QoAAAANLUXE9DOk3_ZkdMLhQh5u NNTP-Posting-Host: 132.154.93.228 References: <#yHIJr1vDHA.1576@TK2MSFTNGP11.phx.gbl> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: BCP or Bulk Insert file containing quoted strings, embedded delimiters From: Code The Crab Injection-Date: Fri, 28 Aug 2020 11:38:00 +0000 Content-Type: text/plain; charset="UTF-8" X-Received-Bytes: 2352 X-Received-Body-CRC: 3144951508 Xref: csiph.com microsoft.public.sqlserver.programming:31368 On Thursday, 11 December 2003 at 01:57:00 UTC+5:30, Robert Tuck wrote: > Dang, that was fast! I'll check it out. Thanks, Lindawie! > > "lindawie" wrote in message > news:%23yHIJr1...@TK2MSFTNGP11.phx.gbl... > > Robert, > > > > > 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.) > > > > You can use a bcp format file for this. Some examples: > > > > http://www.google.com/groups?q=+first_quote+author:lindawie > > > > > > Linda > > > > > > 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