Split document by number of characters - quotation not recorgnized

[jhaastBI]

Hello people,

Currently, I'm importing a text file with lines of data with the comma-separated values function.

Every line contains eg. an itemnumber(always characters 0-10), item description(11-45) and a quantity(46-50). 

However, when I want to import this file some rows contain quotation marks (") that are not recognized by position. This results in incorrect imported lines because the line contains 2 characters less.

Normal line: 

0123456789abcdefghijklmnopqrstuvyxzabcdefghijklmnop10000

0123456789abcdefghijklmnopqrstuvyxzabcdefghijklmnop10000

split as

Itemnumber	Itemdescription	Quanitity
0123456789	abcdefghijklmnopqrstuvyxzabcdefghijklmnop	10000
0123456789	abcdefghijklmnopqrstuvyxzabcdefghijklmnop	10000

Exeptional line:

0123456789abcdefghijklmnopqrstuvyxzabcdefghijklmno"10000

0123456789abcdefghijklmnopqrstuvyxzabcdefghijklmno10000

split as

Itemnumber	Itemdescription	Quanitity
0123456789	abcdefghijklmnopqrstuvyxzabcdefghijklmno"	10000 0123456789 abcdefghijklmnopqrstuvyxzabcdefghijklmnop 10000

Does anybody know how or which Comma-separated option can handle the quotation marks?

Current settings:

Thank you in advance.

[jhaastBI]

Does somebody know how to deal with " when importing a .txt file with seperation by position?

[YukiK]

You could use "Replace values" after importing data:

[jhaastBI]

In the screenshot below the original line was NIKO MINI PATCH 19", however de quotation marks are replaced with the following formule. But the replacement in Power BI did not make sense. Only replacement in the orginal file make sense.