Tab-delimited with format file

Similarly, the following example creates tab-delimited output from the table pubs2..publishers in the pub_out file.

bcp pubs2..publishers out pub_out

The results as stored in the pub_out file are:

0736		New Age Books							Boston				MA
0877		Binnet & Hardley							Washington				DC
1389		Algodata Infosystems							Berkeley				CA

The contents of the pub_fmt format file are:

10.0
4
1		SYBCHAR 04   "\t"  1 pub_id
2		SYBCHAR 040  "\t"  2 pub_name
3		SYBCHAR 020  "\t"  3 city
4		SYBCHAR 02   "\n"  4 state