Tame Your Files Using Pipe Command
Overview Can use "Unix pipes" when checking access logs or making new files from other files. Why have to use pipes? No additional software required → good for making common manual Using other tools can make mistake → miss in copy&paste when using Excel In Access Logs You may want to know how many users access to your site. 1. Sample access logs are as below. 2. Then can use pipes as below. grep -v "HOME" : Exclude access from HOME(ex. redirect access from application itself) cut -d' ' -f1,7,11,12 : Considered space as a field delimiter then print fields in 1, 7, 11, 12 sort | uniq -c : Sorting then count the unique rows. Have to "sort" before "uniq" because "uniq" only check unique in consecutive values. sort -nr : sort by number in reverse order In CSV Files Business team give you an csv files that including delivery information then said "We want to give free delivery to users ...