Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

bcp

Status
Not open for further replies.
bobk5444

bobk5444

Programmer
Joined
Jan 28, 2005
Messages
17
Location
US
hello,
when i run a bcp using:

... out -c t'|'

the downloaded data contain spaces in the output format ie:

"abcde |" instead of:

"abcde|"

any way to remove the spaces?

Thanks very much!
BobK
 
Sort by date Sort by votes
when you write your query you can use the TRIM() function on that column
 
Upvote 0 Downvote
ok good idea thanks for the tip!

have a great week and thanks for taking the time to help me on this!

bobk
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

heyindy11
  • Locked
  • Question Question
Sybase BCP out with sort?
Replies
0
Views
230
heyindy11
heyindy11
gchalise
  • Locked
  • Question Question
BCP of few records from a big table
Replies
1
Views
334
PDreyer
PDreyer
zum
  • Locked
  • Question Question
BCP out Help.
Replies
1
Views
198
yelworcm
yelworcm
zum
  • Locked
  • Question Question
bcp file size.
Replies
1
Views
252
PDreyer
PDreyer
babeo
  • Locked
  • Question Question
What size of a table and bcp for specific date of data
Replies
2
Views
236
babeo
babeo

Part and Inventory Search

Sponsor

Back
Top