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

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

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

Show all headers | View raw

Code The Crab presented the following explanation :
> 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

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.

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous 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