Shell Programming and Scripting

Code:

awk -F'[, ]' '$4=="d" && $3>=14 && $3<=100' myFile

just modify the above to modify your integer value ranges.

Fantastic that worked!!!

Any chance you can explain how that worked?

What does the $4=="d" do? Is that looking 4 placed in front of d?

$4 is the forth field. The field separator is specified by -F'[, ]' . So it's either a comma or a space. Now look at your sample data

Ahhh.....now I see it. Thanks Again!

Code:

124mob7,iOS 8.3,iPad Air 2,6.3,DMPNRMTHG5VJ,1 h 4 m,908D6C582D84
M215POD2,iOS 8.3,iPod touch 5th gen,6.2,CCQPM37YFMJF,10 d 22 m,48E9F12FD989
M155POD072,iOS 8.2,iPod touch 5th gen,6.3,CCQM129ZF4K1,31 d 3 h,F827939F3D33
M115POD053,iOS 8.3,iPod touch 5th gen,6.3,CCQMCCTGFMJF,3 d 0 h,B03495D4AE6F

Code:

awk -F'[, ]' '$9=="d" && $6>=14'

Hi Guys like my name says I'm still struggling with this. The last code I had worked great but now they want more data from our devices and now I'm not able to get back my data by filtering it the same way. I made a change to the awk command to go to the 9th column which I think is correct but I have also tried it with 10 or 11 and I get different results. Any help as to why I'm now not able to get back the data that I want and sort it correctly?

I think my issue is that I have different data in column 3. Sometimes its 2 words and 1 space, 3 words and 2 spaces or 4 words and 3 spaces. Would I need a while loop or something like that? If so can you provide an example?

Thanks

You may want to run this against your sample file:

Code:

awk -F"[, ]" '{for (i=1; i<=NF; i++) print "field", i, ": ", $i}' file

This is a nice piece of code THANKS! It showed me that I sometimes have 12 fields or 13 or 14. I would guess that this is where my problem is. This is where I now think a while loop or something might be what I need to address the variance in the column???