Welcome to HBH! If you have tried to register and didn't get a verification email, please using the following link to resend the verification email.

Need some help with a script


ghost's Avatar
0 0

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-


ghost's Avatar
0 0

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?


ghost's Avatar
0 0

Nevermind, I figured out how to do it.

If you want I can post the script I wrote.