How to change delimiter for CSV Export

Products

• Data Loss Prevention Enforce
• Data Loss Prevention
• Data Loss Prevention Discover Suite
• Data Loss Prevention Enterprise Suite
• Data Loss Prevention Network Discover
• Data Loss Prevention Plus Suite
• Data Loss Prevention Endpoint Discover

Issue/Introduction

If you need to export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel -- via the Control Panel.

 

Resolution

Go to the Control Panel –> Regional and Language Options (or Date, Time and Regional Options –> Regional and Language Option on some machines) –> click the Customize button. In the dialog box that opens you will see and option for "List separator" in which you can change the comma to a different character –> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.