Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | 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