Sublime-Text-Advanced-CSV icon indicating copy to clipboard operation
Sublime-Text-Advanced-CSV copied to clipboard

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

Open dahanbn opened this issue 8 years ago • 4 comments

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
}

dahanbn avatar Sep 05 '17 08:09 dahanbn

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?

Bobtron2000 avatar Feb 22 '18 08:02 Bobtron2000

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?

wadetb avatar Mar 28 '18 00:03 wadetb

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

Korsani avatar Nov 19 '20 14:11 Korsani

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.

laurasra avatar Feb 24 '22 16:02 laurasra