Re: How to specify null delimited in format file

Hey gr8 men, this is a good link that you provided.Helped me to resolve
my problem.
Thanks for the help.....

-Subind.

SybaseNeal wrote:
Hello,

You can specify that NULL be the field terminator with "\0:

http://manuals.sybase.com/onlinebooks/group-as/asg1251e/utility/@Generic__BookTextView/4764;pt=4764

For example:

% cat bcp.fmt
10.0
9
1 SYBCHAR 0 11 "\0" 1 au_id
2 SYBCHAR 0 40 "\0" 2 au_lname
3 SYBCHAR 0 20 "\0" 3 au_fname
4 SYBCHAR 0 12 "\0" 4 phone
5 SYBCHAR 1 40 "\0" 5 address
6 SYBCHAR 1 20 "\0" 6 city
7 SYBCHAR 1 2 "\0" 7 state
8 SYBCHAR 1 12 "\0" 8 country
9 SYBCHAR 1 10 "\0" 9 postalcode

.