For example, you have data in excel that looks like:
|Fig 1: Original format of data|
|Fig 2: Save as Comma separated file|
After saving the file data will look like below:
|Fig 3: Data after converting into CSV|
However, you need to have pipe delimited instead of comma delimited, how do you do that? Please follow the below steps to save file as pipe delimited.
If you are using Windows 10, then you need to go to Settings and then you will find below:
|Fig 4: Settings in Windows 10|
Now please click "Time and Language" option then you will find below screen, where you need to click "Additional time & regional settings" button.
Now you will find below option:
|Fig 5: Related Setting area|
|Fig 6: More click|
|Fig 7: Additional settings|
|Fig 8: List seperator|
So achieved your goal. However, please remember to change your settings back if you want to have your data as comma delimited.