Struggling to change the CSV format to comma separated from semicolon separated despite changing the regional settings etc.

[JayGatsby]

Hi guys,

I would like to ask for a help related to saving the CSV file in the UTF 8 encoding with comma delimiter as so far I was not able to achieve this.

I have tried to traditionally save the the excel sheet as CSV UTF-8, however when opening the file in Notepad++, I can see that the limiter remains as semicolon. Following this I did some research and also tried to change the the regional settings of my machine to make sure that the list separator is set to ","instead of ";" - once again, no success.

Lastly I have also followed instructions on Microsoft forum and played around with delimiters in the advanced settings of excel, yet, when opening the file in Notepad ++ the delimiter remains unchanged.

I do understand that i could do a manual find/replace in Notepad ++, but that doesn't really work for me as I want all my CSVs to be using the column separator unless I specify otherwise.

Would anybody be able to help with this?

I am not attaching the excel file as this does not seem to be allowed here, however, here is the screenshot from Notepad ++ and attempt to paste the content using the XL2BB.

Lastly, could this perhaps be somehow hard-coded on the data source side (as this file was previously extracted from sql server) - is there any way to amend it?

Your help is much appreciated.

samplecsv.csv
	A	B	C	D	E	F	G	H	I	J	K	L
1	field	input	date	name	issues	Gender	facts	Date Of Birth	Country Of Birth	location
2	Operation1	4434	PLUS	MNJKL	VELGRA	M	GBR	June	Mali	GBR
3	Operation2	4434	PLUS	MNJKL	OLGA	F	GBR	July	Mali	GBR
4	Operation3	4434	PLUS	MNJKL	POINTER	F	GBR	August	Mali	GBR
5	Operation4	4434	PLUS	MNJKL	FILAN	F	GBR	September	Mali	GBR
6	Operation5	4434	PLUS	MNJKL	FILAN	F	GBR	October	Mali	GBR
7	Operation6	4434	PLUS	MNJKL	FILAN	F	GBR	November	Mali	GBR
8
samplecsv

 

[yky]

You can upload the file to a document-hosting site on the net and post a link here.

I copied and pasted the data in your post and saved the file in comma separated cvs file format. I then opened the file using notepad. I saw only comma, not semicolon. I tried it on both US and UK regional settings. Results were identical, no semicolon.