Fix lists - Migrate from semicolon to comma as separator

[koppor]

GitHub encounters issues at the CSV files.

Go through each file at https://github.com/JabRef/abbrv.jabref.org/tree/main/journals and check for the issues:

Example: https://github.com/JabRef/abbrv.jabref.org/blob/main/journals/journal_abbreviations_acs.csv

ARKIVOC (Gainesville, FL, United States);ARKIVOC (Gainesville, FL, U. S.)

Does the comma need to be escaped here?

[northword]

https://github.com/annexare/Countries/blob/master/dist/countries.csv

What it looks like we should do is put the full name and abbreviation in a pair of quote marks, respectively, and change the separator from a semicolon to a comma, so that GitHub will automatically recognize it and display it in separate columns, e.g.

"ACS Applied Materials & Interfaces","ACS Appl. Mater. Interfaces"
"Acta Crystallographica, Section F: Structural Biology Communications","Acta Crystallogr., Sect. F: Struct. Biol. Commun."

[Siedlerchr]

No we stick with semicolon. Github is broke. I already raised an issue about this in 2019 https://github.com/orgs/community/discussions/22405

[koppor]

This is a rabbit hole... Finding https://stackoverflow.com/q/10140999/873282, I found the RFC 4180: https://www.ietf.org/rfc/rfc4180.txt. Even more intersting reading: https://en.wikipedia.org/wiki/Comma-separated_values#Standardization

Finally, there is a good overview of existing "standards" by W3C at https://w3c.github.io/csvw/syntax/#standards.

[Siedlerchr]

Decision: We migrate to comma.

[koppor]

We discussed internally. We are OK with switchting from ; to ,.

Please

• update all lists
• update all scripts
• Change the delimiter in JabRef's code at https://github.com/JabRef/jabref/blob/69797bcae455c1671d4aac19e8cab46b0fb1911c/src/main/java/org/jabref/logic/journals/AbbreviationFormat.java#L7

[Hisiste]

Hi! Can I take this issue? :)

[ThiloteE]

@Hisiste Sorry for the late response. Northword is already working on this and we failed to mark this issue as "reserved". If you still need a project, please have a look at our "free to take" issues from the "good first issues" projects page at: https://github.com/orgs/JabRef/projects/5