使用逗号行分隔符导出BCP

I currently have a sproc that is exporting data to a csv file using bcp. It currently works fine except due to a change of requirment the file no longer can have a '\n' row delimiter and must now have a ',' row delimiter. From a quick search I found that the tag you need to add is '-r I currently have a sproc that is exporting data