RE: [csforum] problems with commas

[David Carter]

Title: Message

Hi Ewan,   I'm afraid Mike M is no longer around; I am his replacement at Commtest Instruments and in the interests of keeping up his high level of software support (even for non-customers :) I will endeavour to answer your question!   The problem with CSV files is that they are not CSV files : they are in fact Windows List Separator Files. The value that windows uses for list separation can be found in the locales set up on the machine Control Panel -> Regional and Language Settings -> Regional Options -> Customize -> List separator. Your Swedish client should change this to a ',' or you will need to export a file that uses whatever he has his list separator set to.   Cheers, David -----Original Message----- From: E & A. Fraser, ArchEng [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 10:25 p.m. To: Canterbury Software Email Forum Subject: [csforum] problems with commas I'm sure this is a common problem, but it has been many years since I last saw it. (Mike M are you still around?)   My Windows app writes data to a CSV file so that Excel can be used to analyse it further.   My client has a customer in Sweden who is unable to load the CSV files correctly - all data ends up in one column. I assume that this is because on the customer's PC it is expecting an alternative character in place of the comma (ascii 0x2C), or maybe it expects a comma instead of the decimal point (ascii 0x2E) that is in some of the data fileds.   If my app needs to be altered to fix this then is there a Windows API that allows me to find out how various characters should be represented on the target PC? Or is there a better solution?   Thanks   Ewen Fraser ArchEng Designs Ltd