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

Question

Azure ML support says to me that delimiter must be a comma, this would cause too much hassle with data having semicolon as separator and with a lot of commas in the cell values.

So how to process semicolon separated CSV files in Azure ML?

Answer 1

Only comma , seperated CSV are accepted in the Azure ML.

Try to push a little, just open your data using any text editor (like notepad or ++ version of it).

Find and replace all the semicolons in "tab" (convert it to TSV), you can add commas in the data values, that should not be a problem.

Do define that your input is a TSV, not a CSV.