Follow us on Twitter!
Become the change you seek in the world. - Gandhi
Monday, April 21, 2014
Navigation
Home
HellBoundHackers Main:
HellBoundHackers Find:
HellBoundHackers Information:
Learn
Communicate
Submit
Shop
Challenges
HellBoundHackers Exploit:
HellBoundHackers Programming:
HellBoundHackers Think:
HellBoundHackers Track:
HellBoundHackers Patch:
HellBoundHackers Other:
HellBoundHackers Need Help?
Other
Members Online
Total Online: 28
Guests Online: 26
Members Online: 2

Registered Members: 82852
Newest Member: sockpuppets
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.