pattern { action }
pattern { action }

# Print seluruh file
awk '{print}' file.txt

# Print baris tertentu (line 5)
awk 'NR==5' file.txt

# Print baris dengan pattern
awk '/pattern/' file.txt

# Print field tertentu (default delimiter: whitespace)
awk '{print $1}' file.txt    # Field pertama
awk '{print $NF}' file.txt   # Field terakhir
awk '{print $1, $3}' file.txt # Field 1 dan 3

# CSV file dengan comma delimiter
awk -F',' '{print $1, $2}' data.csv

# TSV file dengan tab delimiter
awk -F'\t' '{print $1}' data.tsv

# Multiple delimiters
awk -F'[:,]' '{print $1}' file.txt  # Delimiter : atau ,

# Regular expression sebagai delimiter
awk -F'[ \t]+' '{print $1}' file.txt  # Whitespace

# Print dengan separator custom
awk '{print $1 " - " $2}' file.txt

# Calculate total dari field
awk '{sum += $3} END {print sum}' numbers.txt

# Average dari field
awk '{sum += $1; count++} END {print sum/count}' data.txt

# Find max/min
awk 'max < $1 || NR==1 {max = $1} END {print max}' data.txt
awk 'min > $1 || NR==1 {min = $1} END {print min}' data.txt

# Count non-empty fields
awk '{for(i=1;i<=NF;i++) if($i!="") count++} END {print count}' file.txt

# Exact match
awk '$1 == "value"' file.txt

# Regex match
awk '$2 ~ /regex/' file.txt

# Negation
awk '$2 !~ /regex/' file.txt

# Numeric comparison
awk '$3 > 100' file.txt
awk '$3 < 50' file.txt
awk '$3 >= 100 && $3 <= 200' file.txt

# String comparison
awk '$1 > "m"' file.txt  # Alphabetic comparison

# Multiple conditions
awk '$1 == "admin" && $3 > 1000' file.txt
awk '$1 == "user" || $1 == "admin"' file.txt

# BEGIN - dijalankan sebelum processing file
awk 'BEGIN {print "Header"} {print}' file.txt

# END - dijalankan setelah processing file
awk '{sum += $1} END {print "Total:", sum}' file.txt

# NR - Record/line number
awk 'NR==1 {print "First line"}' file.txt
awk 'NR%2==0' file.txt  # Even lines
awk 'NR>1 && NR<=10' file.txt  # Lines 2-10

# NF - Number of fields
awk 'NF > 5' file.txt  # Lines dengan lebih dari 5 fields
awk 'NF == 0 {print "Empty line"}' file.txt

# Count requests per IP
cat access.log | awk '{print $1}' | sort | uniq -c | sort -rn | head -20

# Atau dengan AWK saja
awk '{count[$1]++} END {for(ip in count) print count[ip], ip}' access.log | sort -rn | head -20

# Find 404 errors dengan referer
awk '$9 == 404 {print $1, $7, $11}' access.log

# Calculate response time average
awk '{sum += $10; count++} END {print "Avg response time:", sum/count "ms"}' access.log

# Find most requested URLs
awk '{url[$7]++} END {for(u in url) print url[u], u}' access.log | sort -rn | head -10

# Bandwidth usage per IP
awk '{bytes[$1] += $10} END {for(ip in bytes) print bytes[ip], ip}' access.log | sort -rn | head -20

# Error count per hour dari syslog
awk '/error/ {hour=substr($3,1,2); count[hour]++} END {for(h in count) print h, count[h]}' /var/log/syslog

# Failed SSH login attempts
awk '/Failed password/ {print $11}' /var/log/auth.log | sort | uniq -c | sort -rn | head -10

# Disk space trend dari df output
df -h | awk 'NR>1 {sum += $3} END {print "Total used:", sum/1024/1024 " GB"}'

#!/usr/bin/awk -f

BEGIN {
    FS=","
    OFS=" | "
    print "Name", "Department", "Salary"
    print "----", "----------", "------"
}

{
    total += $3
    count++
    
    if ($3 > 50000) {
        print $1, $2, "$" $3
    }
}

END {
    print ""
    print "Average Salary: $", total/count
    print "Total Employees:", count
}

chmod +x process.awk
./process.awk employees.csv
# atau
awk -f process.awk employees.csv

# Convert CSV to TSV
awk 'BEGIN {FS=","; OFS="\t"} {$1=$1; print}' input.csv > output.tsv

# Format currency
awk '{printf "$%.2f\n", $1}' prices.txt

# Pad numbers dengan leading zeros
awk '{printf "%04d\n", $1}' numbers.txt

# Date formatting
awk '{gsub(/-/,"/"); print}' dates.txt  # Replace - with /