1 Reply Latest reply on Sep 3, 2015 8:07 AM by Steven Hawkins

    Non-whitespace character found

    Morgan Kisienya Newbie

      Hi,

      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

       

      "field1"|"field2"|"field3"|"field4"


      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?

       

      texttable.png

       

      Regards

       

      Morgan