Why does exporting the BOM as CSV use semi-colons instead of commas?

On 15/05/14 23:46, RoboticsGuy wrote:

Unless I'm missing something, it appears cadsoft doesn't understand that

CSV stands for "comma-separated values." When I export the BOM choosing

the output format as CSV, Eagle outputs a file that uses semi-colons as

field separators instead of commas. What the heck?!

This is normal and correct. The CSV format is actually "character

separated" where the character can be one of a number of common

punctuation symbols. In many European locales, for example, the comma

character is used as the decimal point, so it couldn't possibly be a

field separator. Thus semicolon is the commonly used separator. A lot of

software will do this depending on your OS locale settings.

 

The problem is that I need to be able to open the BOM in Excel.

That's not a problem

Currently this means after exporting the BOM, I have to open it in a

text editor and use search & replace to change all of the semi-colons to

commas.

No, it doesn't. Excel is quite capable of opening a semicolon-separated

file, provided you employ the necessary runes. Not being a regular Excel

user I can't remember the details (and in any case Microsoft insist on

changing those sort of things with every version). I know how to do it

in OpenOffice, which basically just offers the dialog box every time -

you untick "comma" and tick "semicolon" instead.

On 15/05/14 23:46, RoboticsGuy wrote:

Unless I'm missing something, it appears cadsoft doesn't understand that

CSV stands for "comma-separated values." When I export the BOM choosing

the output format as CSV, Eagle outputs a file that uses semi-colons as

field separators instead of commas. What the heck?!

This is normal and correct. The CSV format is actually "character

separated" where the character can be one of a number of common

punctuation symbols. In many European locales, for example, the comma

character is used as the decimal point, so it couldn't possibly be a

field separator. Thus semicolon is the commonly used separator. A lot of

software will do this depending on your OS locale settings.

 

The problem is that I need to be able to open the BOM in Excel.

That's not a problem

Currently this means after exporting the BOM, I have to open it in a

text editor and use search & replace to change all of the semi-colons to

commas.

No, it doesn't. Excel is quite capable of opening a semicolon-separated

file, provided you employ the necessary runes. Not being a regular Excel

user I can't remember the details (and in any case Microsoft insist on

changing those sort of things with every version). I know how to do it

in OpenOffice, which basically just offers the dialog box every time -

you untick "comma" and tick "semicolon" instead.