CSV with strings in quotes containing quotes inside - parsing issue.

Problem:

user is trying to parse CSV file in which strings are enclosed into quotation marks and inside strings quotation marks are also present. This leads parser to misinterpretation and file is parsed incorrectly.

Solution:

As a workaround we can open the file in OpenOffice and save it as .xls then parse and translate .xls file.

At the end we open translated .xls file in OpenOffice again and use the option to save the file in CSV format, setting desired settings in the CSV settings window.