• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

BCP expert help please, parse out data that is double space delimited

I tried doing this using TSql but not much luck.  It keeps treating double space as single space.  Can someone show an example using BCP to parse out a column that has list with double space delimited data like
1111 breast  neck  Anatomic Pathology

This should parse out to 3 rows of data with the same id of 1111

Thank you.
0
lapucca
Asked:
lapucca
1 Solution
 
elimesikaCommented:
HI

Both -t (field terminator) and -r (row terminator) bcp parameters excepts a single character as its input.

See

http://msdn.microsoft.com/en-us/library/aa174646%28v=sql.80%29.aspx

Apart for that, each row in the file maps exactly to one record in the target table.

I didn't understand how your input maps to 3 records .....
0
 
lapuccaAuthor Commented:
Thank you.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now