 Consider a situation where you get a CSV file from your client to import in your application. But the problem is your application supports only pipe separated files. So here one thing to note is CSV file is not always necessary to have a coma as a separator. It can also contain a pipe or some other character also. So now the question is how can you change your default separator from coma to say pipe character. So let's jump in to see that how we can change this windows setting. Alright so now I am in the control panel of my system. My operating system is Windows 10. Okay so in the control panel first of all you need to click on this region icon which will open one window like this and then click on this additional settings button which opens a new popup like this. Now here you can see the list separator. So over here what you need to do is instead of coma I am changing it to a pipe character and then click on Apply and OK button. Once again click on Apply and OK button. Okay now let me show you the CSV file in the text editor which we were received from the client to import in the application. Alright so here you can see that this file is delimited by coma each column and their respective fields are delimited by coma. Now let's open this file in Microsoft Excel and once again save as this file and see what happened. Okay so now in the Excel sheet let me click on the file menu and click on this save as option. Select this folder and let me give the another name say import patient underscore 1 2 3. Let me click on the save button. Now let us close this file. Alright so here is our new file now since I have changed my coma into pipe from the region culture setting. So what I expect to find now is I expected to have a pipe as delimiter. So let's check this file in text editor. Now let me open the file in Visual Studio Code and yes sure enough instead of coma now we have a pipe as a separator in this CSV file and even if you open this file in Excel then it looks same as before. So this is how you can change the default separator from the windows setting.