Hi everyone,
I’m trying to import CSV files to the string tables. But the strings include double quotation marks failed to be imported and pop up “BadDataException: You can ignore bad data by setting BadDataFound to null.” error.
I’ve tried using ", but it’s not working.
How can I include double quotation marks in the string?
Thank you in advance.
If you are editing the csv file by hand then you need to add double quotations (“”)
E.G
This contains “quoted” text => “This contains ““quoted”” text” “Some Text” => “““Some Text”””
If you are unsure, then add the quotes in the table editor and export them to CSV through the table editor, it will generate the correct quotation formatting for you.