Skip to content

P5 csv files

Giannis KostisMember for 21 years 4 months
Created
5
1
0
I am running a report in p5 and i select to export the results in csv file. In p3 i used csv.xls to convert the csv file (and then process the file with MS Excel) but it isn’t work with p5 csv files. Any good advice to convert p5 csv files?

Thanks in advance !

5 replies

Oldest first
  1. 0
    Julie Scully ·
    Hi Giannis

    I usually open MS Excel and then open my file from there. Haven’t had any prolems to date.

    Cheers
    Julie
  2. 0
    Giannis Kostis ·
    Hello Julie,

    That is what i am doing, the but the results appear like that:

    ,,,,,,Late ,,,,,,,,"9444,44","20370,37","19444,44","21296,30","24074,07","46296,67"
    ,"53241,25","43991,24","63888,90","68518,53",

    Any tip to transform them into a table ?

    Thanks !
  3. 0
    Karim Mounir ·
    yes, i think
    open the excel file, select the data click on "Data" --> "Text to columns" -->
    "Delimited" --> then select Comma and click on next.
  4. 0
    Karim Mounir ·
    yes, i think
    open the excel file, select the data click on "Data" --> "Text to columns" -->
    "Delimited" --> then select Comma and click on next.
  5. 0
    Giannis Kostis ·
    It works fine !

    Thanks Karim

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?