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

Posted on 2011-05-10
Last Modified: 2012-05-11
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.
Question by:lapucca
    LVL 19

    Accepted Solution


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


    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 .....

    Author Closing Comment

    Thank you.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now