6 Replies Latest reply: Aug 14, 2018 4:38 AM by Ruggero Piccoli RSS

    CSV Format Report Separator Change in NPrinting 17.3.1.0

    samrat gupta

      Hi All,

       

      I generated a Qlik Entity Report in NPrinting, the output format is .csv and found the separator is Comma.

       

      In the report I want to change the separator from comma to white-space.

       

      Is there any possible way to solve this?

       

      The Nprinting version is: 17.3.1.0.

        • Re: CSV Format Report Separator Change in NPrinting 17.3.1.0
          Edgar Kech

          Hi all,

          OK, this is an old thread, but the problem still persists.

          I am on NPrinting April 2018 Release (18.9.5) connecting on a Qlikview 12.something server.

          Object is a straight table chart which has to be exported as CSV, but with semikolon as separator.

          Qlik suggests using "SKV" as output, but surprise - "SKV" delivers exactly the same output as "CSV" with comma as separator and not a semikolon as you might expect.

          So, is there a way to get a semikolon-separated file - and I am NOT talking about concatenating all expressions into one...???

          • Re: CSV Format Report Separator Change in NPrinting 17.3.1.0
            Ruggero Piccoli

            Hi,

             

            When you add a Qlik Entity report into a task you can select among CSV, SKV and TAB output formats.

            csv output formats.jpg

            If you cannot see these options in your installation, please update it to latest available.

             

             

            Best Regards,

            Ruggero

            ---------------------------------------------

            When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

              • Re: CSV Format Report Separator Change in NPrinting 17.3.1.0
                Edgar Kech

                Thanks Ruggero, but....

                 

                ... that's exactly what I did during my tests. Unfortunately the options CSV, SKV and TAB deliver EXACTLY the same output (OK, the file suffix is different). I always end up with a comma separated file.

                So for me this looks like a little nasty bug, at least in 18.9.5 (which is currently my only accessible version to play with).

                  • Re: CSV Format Report Separator Change in NPrinting 17.3.1.0
                    Ruggero Piccoli

                    Hi,

                     

                    This is strange. I tested the solution in Qlik NPrinting June 2018 (latest GA version) before to answer you and it worked fine. I also checked the June 2018 Release Notes and there are not solved bugs on this topic.

                     

                    Could you update to June 2018 and test with it?

                     

                    Best Regards,

                    Ruggero

                    ---------------------------------------------

                    When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.