1

hi all,

i attach the csv that im trying to extract some data out of it

i have done this command -

awk -F’,’ ‘{print $1,$4,$5,$6}’ 16-02-2017_XSAreport.csv

and it works awesome, only problem is i want to miss out rows 1, 2 and 3, but im struggling abit

https://s24.postimg.org/ywixdljb9/data.png

cheers,

rob

3 Spice ups
2

tail -n+4 filename.csv | awk ‘{print $1,$4,$5,$6}’

This might work, in theory.

tail -n+4 starts on the fourth line of the file I think

1 Spice up
3

That would work. So would this:

awk -F',' '{if (NR>3) {print $1,$4,$5,$6};}' 16-02-2017_XSAreport.csv

NR is a reserved word in Awk and is the row number. So, if the row number is greater than 3, do the print. If a pattern doesn’t match (in this case, NR > 3) then Awk does nothing.

1 Spice up
4

awk -F’,’ ‘NR>3 {print $1,$4,$5,$6}’ 16-02-2017_XSAreport.csv

5

now i want to work out the difference between 2 csv reports i have run the awk command on

using the awk command on the csv i gave you i get these results -

Reception 0 0 0
Runners 0 0 0
molinare 136030 46301 8084
Carnaby 3 44 41 58
Sales 4 1 1
Xerox Administrative Group 0 0 0
Bookings 151 36 71
Accounts 135831 46223 7954
IT Admin 0 0 0
XRX_DEF 0 0 0
Admin 0 0 0
Diagnostics 0 0 0
Print Exceptions Group 0 0 0
Guest 0 0 0

so lets say i have this days report and i produce another report (using the csv and running an awk command)

how do i work out the differences for the customer “carnaby 3” so report 1 is 44 41 58 and lets say report 2 is 48 45 60

how do i show the difference ie 4 4 2

many thanks,

rob

6

mmm…

got abit of a problem and i dont know why this is happening

im doing this command and this is the result i get -

#awk -F’,’ ‘NR>3 {print $1,$4,$5,$6}’ 26-01-2017_XSAreport.csv 16-02-2017_XSAreport.csv
Reception 0 0 0
Runners 0 0 0
molinare 135986 46262 8026
Carnaby 3 0 2 0
Sales 4 1 1
Xerox Administrative Group 0 0 0
Bookings 151 36 71
Accounts 135831 46223 7954
IT Admin 0 0 0
XRX_DEF 0 0 0
Admin 0 0 0
Diagnostics 0 0 0
Print Exceptions Group 0 0 0
Guest 0 0 0
Account Name Counter: Total Black + Level 1 Copy and Print Impressions Counter: Total Color Level 2 Copy and Print Impressions Counter: Total Color Level 3 Copy and Print Impressions
Customer Service Engineer Account 0 0 0
System User 316 129 23
Reception 0 0 0
Runners 0 0 0
molinare 136030 46301 8084
Carnaby 3 44 41 58
Sales 4 1 1
Xerox Administrative Group 0 0 0
Bookings 151 36 71
Accounts 135831 46223 7954
IT Admin 0 0 0
XRX_DEF 0 0 0
Admin 0 0 0
Diagnostics 0 0 0
Print Exceptions Group 0 0 0
Guest 0 0 0

but the problem is why on the second file is it not doing the NR>3 ie its not missing the first 3 lines?

7

resolved it -

awk -F’,’ ‘FNR>3 {print $1,$4,$5,$6}’ 26-01-2017_XSAreport.csv 16-02-2017_XSAreport.csv

8

now i want to calculate the difference between the values in columns 4, 5, 6 in both files and put the output in a new file, so like this

carnaby 3 0 2 0

carnaby 3 44 41 58

so the output file would look like this ie how many prints the client has done between the dates 26-01 - 16-02

carnaby 3 44 39 58

is this going to be easy to do please

many thanks,

rob

9

You might want to just get a copy of Excel

10

i feel so proud!

done it via paste and awk command

paste 26-01-2017_XSAreport.csv 16-02-2017_XSAreport.csv | awk -F, ‘FNR>3 {print $1,$4,$5,$6,$24,$25,$26}’

the reason why i have made loads of print commands is because the csv files consist of 21 columns each so thats why so 24,25,26 is the other columns in the other csv file

and the layout looks like this -

Reception 0 0 0 0 0 0
Runners 0 0 0 0 0 0
molinare 135986 46262 8026 136030 46301 8084
Carnaby 3 0 2 0 44 41 58
Sales 4 1 1 4 1 1
Xerox Administrative Group 0 0 0 0 0 0
Bookings 151 36 71 151 36 71
Accounts 135831 46223 7954 135831 46223 7954
IT Admin 0 0 0 0 0 0
XRX_DEF 0 0 0 0 0 0
Admin 0 0 0 0 0 0
Diagnostics 0 0 0 0 0 0
Print Exceptions Group 0 0 0 0 0 0
Guest 0 0 0 0 0 0

1 Spice up
11

now i need to do the calculations and put it in a new file