As I have indicated before the help in this forum is much appreciated.
I have a CSV with data to be inserted into MySQL. Some of the data is successfully inserted but some of the data generates the following error.
TEIID30183 Text parse error: Non-whitespace character found between the qualifier and the delimiter in text line....
The qualifier and the delimiter in my data are as follows
I have released the error is generated when I have quotes within the text to be inserted e.g.
"|"The quick brown fox "jumps over" the lazy dog"|"
From my reading the solution would be to use TEXTTABLE() method to arrive at a solution.
I have attached an image of the possible TEXTTABLE() function options from Teiid designer. Which one should work?
Or this is this the approach to use?
The entry "The quick brown fox "jumps over" the lazy dog" is not a form we would expect to see. We either want to see the use of an escaping quote:
"The quick brown fox ""jumps over"" the lazy dog"
or for the escape option to be enabled for example with the default of \:
"The quick brown fox \"jumps over\" the lazy dog"