wadetb / Sublime-Text-Advanced-CSV

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

Formatting for numbers with commas fails #50

Open tomhundt opened 6 years ago

tomhundt commented 6 years ago

Hi, this is an awesome package, thanks so much for providing it!

Noticed in one of my files, dollar numeric fields, e.g., [...,] "$100,015.00", [...] don't render properly -- the "string" rendering stops at the comma in the middle, whereupon it changes to the same style as numeric constants and dates. Experimentation reveals that the dollar sign makes it think that's a string-format field (any letter does the same thing). IMO the whole thing should just be displayed as a string, including the embedded comma.

Here's an example one,two,three,four 1,"$200,000",567,hello comes out as render_money_number

Thanks