Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peterlemonjello
Yak Posting Veteran
53 Posts |
 Posted - 2007-02-13 : 15:24:59
|
| I've been asked to modify an existing bcp export to use ctrl+v as the delimiter instead of |. Does anyone know what ctrl+v translates to in text? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-13 : 15:46:45
|
| ctrl+v is the Paste action. I don't think you can use it as a delimiter. I'm pretty sure that delimiters need to be characters and not key combinations.Tara Kizer |
 |
|
|
peterlemonjello
Yak Posting Veteran
53 Posts |
Posted - 2007-02-13 : 15:53:17
|
| They told me the octal number is /026 but I can't use that. I'm with you, I'm not sure if there's a combination of characters to represent ctrl+v or not. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-13 : 16:15:39
|
| Octal 026 is Hex 16, so you can represent it as 0x16It's an ASCII control code SYN (Synchronous Idle)http://en.wikipedia.org/wiki/AsciiCODO ERGO SUM |
|
|
|
|
|
|
BCP ctrl+v Delimeter