Countries with comma as decimal setting - How do you handle this for importing CSV files?
We just encountered a bit of a hiccup with some of our countries saving and loading csv files to our model. It turns out that countries using comma as the decimal have this issue in Microsoft Excel. When they save as a csv, it uses a semicolon as the separator. Even if you change the separator option in Windows/Excel to a period for these countries, it will still save the file with semicolons separating the data rather than commas. Because Anaplan does not recognize the semicolon as a separator it fails to load.
The solution that we have verified with Anaplan Support is for those users to change their number setting, then save the file as a csv. After saving the file, changing their number setting back for their regular reporting needs.
Are there any other workarounds you have identified and used? The only other one would be to change the import file to txt.
To change the number setting in Excel - Go to File, Options, Advanced, uncheck Use system separators, change decimal to period and thousands to comma.
If there's absolutely no way to standardize the csv file into 1 format, then i'm afraid you're right, you'll need 2 separate actions, i.e. one for countries who use comma as decimal and one who use period as decimal.