for reasons unknown our credit card processor produces csv reports that include a comma as a thousands-separator while also using a comma as a delimiter
why this
@KittyUnpretty thats uh, a choice
@Satsuma all they had to do was either use semicolons as a delimiter (they don't appear anywhere in the data) or just exclude number formatting. and yet. here we are.
@KittyUnpretty yeah the fact that it would have been so easy to avoid definitely compounds the effect
How do you even fix something like that?
@KittyUnpretty yeah I’d figured there was at least a chance of having 2 digits before the comma
Glad it wasnt completely nightmarish to sort out
@KittyUnpretty @Satsuma the fact that they use a dollar sign alongside the value is *also* "a choice". Like, if you're dealing with a single currency don't specify the $, otherwise list the currency in an adjacent field. Why is this not obvious to people? Sigh.
@Satsuma in my case i just opened the csv in notepad++ and did a search and replace for "$1," to change it to "$1" before opening the file in excel
if we actually did large amounts of business this would be a mess