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