Recently I had a requirement to convert my Excel data file to CSV format with delimiter as ‘~‘ also known as Tilde. After searching for various options I came across a very simple Setting in the System by the help of which now onwards the Excel data file can be converted to CSV with any type of desired Special Character.
To change the Setting of the System you need to Navigate to:
1> Start -> Control Panel -> Region and Language
2> Under the Formats tab click on Additional Settings
3> Under Numbers tab you can see List Separators option.
4> Change the Value with any of your desired Special Character.
5> Apply to the change and you are Done.
Now Open any Excel file and Save as CSV format.
Now Open the saved CSV file, also with Notepad and you will see the change.
Hope this little System Setting Changes will save you lot of Hard Work and Time for finding the Solutions for the Same. Previously I have also written a post on Saving Excel as Semicolon Delimiter along with Unicode Encoding