Follow us on Twitter!
Things are more like they are now than they have ever been before. - Dwight D. Eisenhower
Sunday, May 29, 2016
Navigation
Home
 Find:
 Information:
Learn
Communicate
Submit
Shop
Challenges
 Exploit:
 Programming:
 Think:
 Track:
 Patch:
 Other:
 Need Help?
Other
Members Online
Total Online: 19
Guests Online: 17
Members Online: 2

Registered Members: 93883
Newest Member: naveen29395
Latest Articles
View Thread

HellBound Hackers | Computer General | Programming

Author

Need some help with a script


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 31-07-06 14:00
Hi,

Need a bit of help from the shell and perl guru's out there.

I have 2 spreadsheet files. One has customer numbers in one column and the order request in the next column. The second file has the order requests that were successful.

I need to get the percentage of succesful requests.

I can use perl or shell to do it. I'm not very familiar in either sed or awk, and I need it done asap. Anyone any ideas?

Thanks

-S-


Author

RE: Need some help with a script


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 31-07-06 15:37
so the first spreadsheet will have like 100 things and the second will have like 30, and the success % will be rows in spreadsheet1 / rows in spreadsheet2, equaling 30%?

Also, is this a csv/tab deliminated or does the spreadsheet contain binary data?


Author

RE: Need some help with a script


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 31-07-06 21:03
Nevermind, I figured out how to do it.

If you want I can post the script I wrote.