How to change delimiter for CSV Export
search cancel

How to change delimiter for CSV Export

book

Article ID: 159979

calendar_today

Updated On:

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.

 


Powered by Wolken Software