11 Replies Latest reply: Feb 7, 2018 9:55 AM by Diana Socha RSS

    Eliminate Quotes of .txt

    Diana Socha

      Hi People

       

      I'm working with Qlik Sense and I have a format problem. I have a QVD table result, I need to convert this QVD to .txt and I do that but in the resultant .txt, the quotes are includes when a coma (" , ") appears, like this:

       

      ABCDEFG00000000001

      "ABCDEFG1250,876807"

      ABCDEFG00000000002

       

      The info in my .txt is like that, numbers separate by comas... I try transform the .txt with Replace(reporte, '"', ' ') but it's like that not exist because not replace nothing!!!!! I need the results with comas and without quotes.

       

      Please Help Me!!!!

       

      Thanks