How to Export to CSV file with Delimiters other than Comma

In earlier version of Excel (before Excel 2010) we dont have an option to select the delimiter to save the file as CSV. Only a user can save with comma delimiter or space delimiter.

however if you have a requirement to create a Pipe Delimited or & delimited csv files, you can do it by following the below steps.

This will work only for Windows 7 / XP and MS Office 2007 packages.

1. Close your Excel
2. Navigate to control panel, Select ‘Region and Language’
3. Click the ‘Additional Settings’ button
4. Find the List separator and change it from a comma to your preferred delimiter such as a pipe (|).
5. Exit Control panel
6. Open the Excel file you want to export to a pipe delimited file
7. Select File, Save As
8. Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’
9. Change the name and file extension if you want, by default stays as csv even though a different delimiter
10. Click Save
11. Click OK
12. Click Yes

Updates on Track Doubling between Ariyalur & Villupuram:

SR General Manager visited the new laid second track between Ariyalur & Villupuram.

Here are few images from Twitter.

 The below photo is disgusting . Is SR dont have any motorized Trolleys?.