Change Terminators from the Command Line

Terminators are the characters that separate data fields (field terminators). The row terminator is the field terminator of the last field in the table or file.

Use the -tfield_terminator and -rrow_terminator command line options with the character format option (-c) to change the terminators from the command line.

This example uses the comma (,) as the field terminator, and returns (\r) as the row terminator.

This bcp command line produces the following information:
0736,New Age Books,Boston,MA
0877,Binnet  & Hardley,Washington,DC
1389,Algodata Infosystems,Berkeley,CA
Note: You can use the -t and -r options to change the default terminators without including the character option (-c).