1 Reply Latest reply on Dec 16, 2010 5:51 AM by Attila Polinger

    Modify CSV separator on exported file in ePo 4.5?

      We are using ePo 4.5 and we run scheduled queries every day in CSV format but we would like to change the separator character from comma to semicolon, because our users read CSV format with MS Excel in French configuration (which consider semicolon as defaut separator for CSV format)

      Is there a way to do it?

        • 1. Re: Modify CSV separator on exported file in ePo 4.5?
          Attila Polinger

          Hi,

           

          we also have regular queries exported in .CSV and we worked out a small command script to change the comma to semicolon in these files. You could schedule a small DOS .CMD script to run after ePO queries are exported to disk. If this suits you I can copy here the relevant script sections..

           

          In my opinion it is hardly likely that ePO will provide for changing commas to semicolons embedded in query export algorithm.

           

          Attila