Groups > microsoft.public.sqlserver.programming > #31368

Re: BCP or Bulk Insert file containing quoted strings, embedded delimiters

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	<upEL4v1vDHA.2316@TK2MSFTNGP10.phx.gbl>
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	<O0LjVl1vDHA.2352@TK2MSFTNGP09.phx.gbl> <#yHIJr1vDHA.1576@TK2MSFTNGP11.phx.gbl> <upEL4v1vDHA.2316@TK2MSFTNGP10.phx.gbl>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<f5ffde02-2fbe-46d7-88d9-4ed1b3ba7062n@googlegroups.com> (permalink)
Subject	Re: BCP or Bulk Insert file containing quoted strings, embedded delimiters
From	Code The Crab <mypassioncoding@gmail.com>
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

Show key headers only | View raw

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" <lind...@my-deja.com> 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

Back to microsoft.public.sqlserver.programming | Previous | Next — Next in thread | Find similar

Thread

Re: BCP or Bulk Insert file containing quoted strings, embedded delimiters Code The Crab <mypassioncoding@gmail.com> - 2020-08-28 04:37 -0700
  Re: BCP or Bulk Insert file containing quoted strings, embedded delimiters Michael Cole <micheal.cole@invalid.com> - 2020-08-31 20:15 +1000

csiph-web