Results 1 to 3 of 3

Thread: bcp copy using special characters

  1. #1
    Join Date
    Sep 2013
    Posts
    2

    bcp copy using special characters

    I am doing bcp export from sql server table to text file. But I am facing problem.Data in table contains special characters sucha as tab, spaces. So when I am exporting the data to text file, it generates extra space or tab in output. So is there any way so that I can eliminate the space or tab in sql server table during bul copy. Can anyone help me?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Instead of exporting table you can export result of a query. The query can use RTRIM on columns with blank spaces so that it does not appear in the export file.

  3. #3
    Join Date
    Sep 2013
    Posts
    2
    Quote Originally Posted by skhanal View Post
    Instead of exporting table you can export result of a query. The query can use RTRIM on columns with blank spaces so that it does not appear in the export file.
    Thank you. But is there any way to detect too many tabs in bcp export.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •