Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter.
When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one column.
In many European countries, the Semicolon is the default delimiter. This is because the comma is used as Decimal separator.
As a workaround, some of our admins / users need to change their systems setting each time they want to save a CSV for upload through ADO.
Preferred solution will be the support for semicolons in ADO uploads
