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

    Non-whitespace character found

    kisienya
    kisienya Sep 3, 2015 6:15 AM

      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

      • 217 Views
      • Tags:
        • 1. Re: Non-whitespace character found
          shawkins
          shawkins Sep 3, 2015 8:07 AM (in response to kisienya)

          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"

            • Actions