October 11, 2008 09:47pm pdt

1. wesgarrison 125,172
2. Gertone 33,900
3. fridom 22,064
4. bobbit31 14,575
5. dberner9 13,550
6. JESii 9,950
7. hobbit72 4,000
8. galori 3,400
9. Adam314 3,300
10. peh803 3,000
11. LocoTechCJ 2,000
11. Badotz 2,000
11. hielo 2,000
11. Plucka 2,000
11. Mandibal 2,000
11. nutsch 2,000
11. aiklamha 2,000
18. zc2 1,500
18. randomutt... 1,500
20. aneeshatti... 1,400
20. rbarazi 1,400
22. Netzpirat 1,364
23. mailBoy2 1,000
23. b0lsc0tt 1,000
23. blimster 1,000
23. duncan_roe 1,000
23. kshitij_ah... 1,000

1. wesgarrison 125,172
2. Gertone 92,575
3. fridom 44,754
4. bobbit31 28,775
5. dberner9 13,550
6. JESii 9,950
7. CEHJ 7,360
8. objects 6,802
9. galori 6,400
10. peh803 5,200
11. ozo 4,675
12. jkr 4,000
12. hobbit72 4,000
14. StillUnAw... 3,620
15. Adam314 3,300
16. jim_cakalic 3,260
17. dlwyatt82 3,200
18. mvidas 3,075
19. bpmurray 3,000
19. DerekHar... 3,000
21. mayankea... 2,984
22. b0lsc0tt 2,600
23. lbertacco 2,500
24. Interactive... 2,200
25. EnolaKotr... 2,100

06.10.2008 at 01:35AM PDT, ID: 23471558

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.7

Ruby script - csv

Asked by philsivyer in Ruby Scripting Language, Microsoft Excel Spreadsheet Software

Hello
I have a csv file delivered daily (with no headers) and needs reconfiguring and written to a new daily file.
It comes in as follows (example) ........
Reference 1
Time Profile Location Location Name Service Availability Transaction Count
09/06/2008 01:00 5 8 Location 1 n/a 6
09/06/2008 02:00 5 8 Location 1 84.20 6
etc etc up to 24 hrs
Reference 2
Time Profile Location Location Name Service Availability Transaction Count
09/06/2008 01:00 7 18 Location 2 100.00 6
09/06/2008 02:00 7 18 Location 2 84.20 n/a
etc etc up to 24 hrs

The output written to a new file needs to be as follows
Header1 Header2 Header3 Header4 Header5 Header6 Header7
Reference 1 09/06/2008 01:00 5 8 Location 1 n/a 6
Reference 1 09/06/2008 02:00 5 8 Location 1 84.20 6
Reference 2 09/06/2008 01:00 7 18 Location 2 100.00 6
Reference 2 09/06/2008 02:00 7 18 Location 2 84.20 n/a

Can the the daily file be coded so it will always have an extension in the filename with todays date?

Regards
PhilStart Free Trial

Keywords: Ruby script - csv

	Title
1	code to save a worksheet as a csv file
2	csv files
3	CSV Coldfusion and MySQL
4	txt to csv
5	Reading CSV file using Visual Studio (…
6	Best way to import SQL data from a C…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Ruby script - csv

Asked by philsivyer in Ruby Scripting Language, Microsoft Excel Spreadsheet Software

About this solution