Search Results

Thanks for this. Can I ask how do I tell awk what files to process. I think its something in here {S[$1]=$2; P[$1]=$3; next} are those variable's that I assign to my perl.csv and account.csv?
...

username time_in_minutes
dwright3 272
esoto1 52
ewhite5 36


The time gets put into the Quantity field of the output.csv

Yes, every month the perl script is run outputting


dwright3 272
esoto1 52
ewhite5 36


Then I need to combine that data with account information (doesnt change, constant)-...

Thanks for the fast reply!

Input is from the various workstations that users log into, via that perl script. It outputs the username and time in minutes,
dronnow 40
dwright3 272
esoto1...

I run a small instrument lab. We track our user's time on the instruments with a very manual process of 'last wtmp.1' then cut/paste data into spreadsheets. My boss makes the initial spreadsheets...