You are receiving the error Error due to unsupported formatting in the CSV file when uploading a CSV file in Data Workbench Workcenter.
Reproducing the Issue
- Go to Data Workbench Workcenter
- Select Import sub tab
- Upload your CSV file
- You receive the error Error due to unsupported formatting in the CSV file
The error is caused because the data in your file contains special characters, but the text was not maintained with quotes.
When there is a special character in text, you must maintain all the text quotated with double quotes.
E.g: "Text with special chara@cter!!"
Whenever there is a quoted sentence in text, you must maintain an extra double quotes.
e.g: "Simple text ""Quoted sentence in text"" Text"
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To