wadetb / Sublime-Text-Advanced-CSV

Efficiently format, edit, arrange, and evaluate cells in CSV files
169 stars 14 forks source link

What do I have to change to use ; as a separator for csv files #46

Open dahanbn opened 6 years ago

dahanbn commented 6 years ago

In Germany a comma isn't usually a separator for csv fields. And my data uses the comma as a decimal point.

What do I have to set in my user settings that the package will only use the semicolon as a field separator for csv files?

I tried the following without any effect:

{
  "delimiter_mapping": {
    "*.csv": ";",
    "*.psv": "|",
    "*.tsv": "\t"
  },
  "delimiter": ";",
  "auto_quote": true
}
Bobtron2000 commented 6 years ago

Second that, semicolon would be much more useful to me. Actually comma is useless to me, often there is at comment section, that will contain comma(s), one of the reasons that standard around here also is semicolon.

And btw. is there a way to change the syntax color?

wadetb commented 6 years ago

Thanks for the report @dahanbn and apologies for the slow reply. I'll investigate using ; as a separator.

Note that it won't affect syntax highlighting - as far as I know Sublime does not allow changing the syntax regex based on settings - though it might be possible to support different syntax files for common cases based on extension?

Korsani commented 3 years ago

Same here! Adding that: right click -> set delimiter -> ';' doesn't work

GitDoggo commented 2 years ago

I managed to have ';' work as a delimiter with the settings but syntax highlighting is a big problem. Everything is the same color, it's less practical than no color at all. At this point I even think a fork of the package where everything is the same except ';' is the default delimiter could be worth it. As it is now, the package is hardly usable for people who work with semicolons.