Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P5 csv files

5 replies [Last post]
Mon, 2006-07-24 12:31
Giannis Kostis
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 23 May 2005
Posts: 11
Groups: None
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 !
Top

Replies

Thu, 2006-07-27 08:28
#1
Giannis Kostis
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 23 May 2005
Posts: 11
Groups: None
It works fine !

Thanks Karim
Top
Thu, 2006-07-27 06:59
#2
Karim Mounir
User offline. Last seen 9 years 49 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
yes, i think
open the excel file, select the data click on "Data" --> "Text to columns" -->
"Delimited" --> then select Comma and click on next.
Top
Thu, 2006-07-27 06:59
#3
Karim Mounir
User offline. Last seen 9 years 49 weeks ago. Offline
Joined: 5 Apr 2006
Posts: 314
Groups: None
yes, i think
open the excel file, select the data click on "Data" --> "Text to columns" -->
"Delimited" --> then select Comma and click on next.
Top
Wed, 2006-07-26 04:44
#4
Giannis Kostis
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 23 May 2005
Posts: 11
Groups: None
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 !
Top
Tue, 2006-07-25 22:27
#5
Julie Scully
User offline. Last seen 16 years 38 weeks ago. Offline
Joined: 9 Nov 2005
Posts: 25
Groups: Petro-Chem / Oil & Gas
Hi Giannis

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

Cheers
Julie
Top