df -> output files; comparison using awk or...


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers df -> output files; comparison using awk or...
# 1  
Old 02-25-2011
df -> output files; comparison using awk or...

Smilie
I am trying to do the following using awk (is that the best way?):

Read 2 files created from the output of df (say, on different days) and compare the entries using the 1st (FileSys) and 6th (Mount) fields to see if the size has changed. Output (at least), to a new file (some header lines) and each record's fields $1, $6, the 2 dir sizes and the delta. Plus append any unmatched lines from the file1.

I have an example (from here) that I'm trying to decipher and adapt to my purpose but am having a difficult time figuring it all out.
Code:
awk 'NR==FNR {A[$1]=$2; next}A[$1]{$1=A[$1]}1' FS=\| OFS=, file1 file2

Any help would (duh!) be greatly appreciated.

Thanx
Renata

Last edited by Scott; 02-25-2011 at 02:37 PM.. Reason: Please use code tags
# 2  
Old 02-25-2011
Post sample input and desired output files.
# 3  
Old 02-25-2011
Wrench df -> output files; comparison; sample files

Roughly this is the format of the files (output from the 'df'
would be a straight dump into Filex.

Maybe awk isn't the right tool?
Thanx
Renata

File1
2/25/2011
Filesystem Size Used Available Capacity Mounted on
/prod 390MB 7398944 29834728 18% /data
/prod/ 252.1MB 1234557 32012367 51% /apps/DPEAS
/prod/ 565.4 MB 217138.6 30256894 10% /data/DPEAS
EOF

File2 2/24/2011
Filesystem Size Used Available Capacity Mounted on
/prod 350MB 7398904 29834768 20% /data
/prod/ 262.1MB 1234567 32012357 50% /apps/DPEAS
/prod/ 565.4MB 217138.6 30256894 10% /data/DPEAS
/home/ 742MB 123456 12345678 16% /MIRS
EOF

Output File
Prev Date 2/24/2011
Curr Date 2/25/2011

old size new size delta filename
350MB 390MB 40 MB /prod/data
262.1MB 252.1MB -10 MB /prod/apps/DPEAS
565.4MB 565.4MB 0 MB /prod/data/DPEAS

742MB /home/MIRS
EOF
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk comparison using multiple files

Hi, I have 2 files, I need to use column of file1 and do a comparison on file2 column 1 and print the mismatch is file3 as mentioned below. Kindly consider that file 1 is having uniq key(column) whereas in file2 we have multiple duplicates (like 44). These duplicates should not come in... (2 Replies)
Discussion started by: grv
2 Replies

2. Shell Programming and Scripting

awk - 2 files comparison without for loop - multi-line issue

Greetings Experts, I need to handle the views created over monthly retention tables for which every new table in YYYYMMDD format, there is equivalent view created and the older table which might be dropped, the view over it has to be re-created over a dummy table so that it doesn't fail.... (2 Replies)
Discussion started by: chill3chee
2 Replies

3. Shell Programming and Scripting

Awk: Replacement using 2 diff files input and comparison

Requirement: If $5(date field) in ipfile is less than $7(date field) in deact file & $1 of ipfile is present in deactfile then $1 to be replaced by $2,$3,$4,$5,$6 of deact file else if $5(date field) in ipfile is greater than $7(date field) in actfile & $1 of ipfile is present in actfile then... (5 Replies)
Discussion started by: siramitsharma
5 Replies

4. Shell Programming and Scripting

awk file comparison, x lines after matching as output

Hello, I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk? I have got two files: file1: Worker1: Thomas Position: Manager Department: Sales Salary: $5,000 Worker2: Jason Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies

5. Shell Programming and Scripting

comparison of 2 files using unix or awk

Hello, I have 2 files and I want them to be compared in a specific fashion file1: A_1200_1250 A_1251_1300 B_1301_1350 B_1351_1400 B_1401_1450 C_1451_1500 and so on... file2: 1210 1305 1260 1295 1400 1500 1450 1495 Now The script should look for "1200" from A_1200_1250 of... (8 Replies)
Discussion started by: Diya123
8 Replies

6. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies

7. Shell Programming and Scripting

Awk Comparison of 2 specific files

Hi Everybody, I know the topic sounds familiar but I just couldn't adapt or find the right code that solves my particular issue. I really hope you can help. I would like to compare 2 files in an awk script. Both files have different paths. The awk script call should look like that awk -f... (7 Replies)
Discussion started by: hhoosscchhii
7 Replies

8. Shell Programming and Scripting

Output format - comparison with I/p file

Hi, I have a file which contains more than 1 lakh records like following: a. name, id, city, state, country, phone (Expected I/P file format) name, id, city,, state, country, phone (Current I/P file format ) I want to achieve following tasks, a, Remove the extra comma in the... (1 Reply)
Discussion started by: velappangs
1 Replies

9. Shell Programming and Scripting

Comparison of two files in awk

Hi, I have two files file1 and file2 delimited by semicolon, And I want to compare column 2 and column3 of file1 to column3 and column 4 in file2. file1 -------- abc;cef;155.67;143_34; def;fgh;146.55;123.3; frg;hff;134.67;; yyy;fgh;134.78;35_45; file 2 --------- abc;cef;155.09;;... (12 Replies)
Discussion started by: jerome Sukumar
12 Replies

10. Shell Programming and Scripting

String Comparison between two files using awk

I have two files with field seperator as "~". File A: 12~13~14~15 File B: 22~22~32~11 i want to calculate the difference between two files and than calculate the percentage difference and output it to a new file. How do i do this using awk. Also please suggest GOOD awk tutorials. Thank... (7 Replies)
Discussion started by: rudoraj
7 Replies
Login or Register to Ask a Question