title: Export CSV file with Pipe delimiter from SharePoint
body: <p>I need to export a file in CSV format with a pipe | delimiter instead of a comma from SharePoint. I have changed my settings locally so the default separator is a pipe symbol. But I have to export the file to Excel and then resave as CSV. This defeats the purpose of automating the report.</p>