Azure ML: How to save and process CSV files with a semicolon as a separator?

Question

Azure ML support tells me that the separator must be a comma, it will cause too much trouble with data with a semicolon as a separator and with a lot of commas in the cell values.

So how to handle semicolon-separated CSV files in Azure ML?

Answer 1

Azure ML accepts only a comma ,separated by CSV. Work a little. Open the data file with a text editor. (Notepad will do the trick). Locate and replace all semicolons with “tab” (do it TSV), and the commas in the data values ​​may not cause a problem. Make sure the input is TSV; not CSV.