Text processing

The full sheet

• awk '{print $2}' Print the second column of any outputguide ›
• awk -F, '{print $3}' f.csv Third column of a comma-separated fileguide ›
• awk '{s+=$1} END {print s}' Sum a columnguide ›
• awk '!seen[$0]++' Deduplicate, preserving original orderguide ›
• sed 's/old/new/g' file Replace every occurrence (prints the result)guide ›
• sed -i.bak 's/old/new/g' f Replace in place, keeping a .bak backupguide ›
• sed -n '20,40p' file Print only lines 20 to 40guide ›
• sed '/^#/d' file Strip comment linesguide ›
• cut -d, -f1,3 file.csv Extract columns 1 and 3guide ›
• sort file Sort lines alphabetically
• sort -nr file Sort numerically, descending
• sort file | uniq -c Count occurrences of each lineguide ›
• sort file | uniq -d Show only the duplicated linesguide ›
• tr 'a-z' 'A-Z' Uppercase everythingguide ›
• tr -d '\r' < win.txt Strip Windows carriage returnsguide ›