Bash Cookbook

Getting ready

Let's get ready for the exercise by creating some data sets which mimic common daily problems:

$ rm -rf testdata; mkdir -p testdata$ echo "Bob, Jane, Naz, Sue, Max, Tom$" > testdata/garbage.csv $ echo "Zero, Alpha, Beta, Gama, Delta, Foxtrot#" >> testdata/garbage.csv $ echo "1000,Bob,Green,Dec,1,1967" > testdata/employees.csv$ echo "2000,Ron,Brash,Jan,20,1987" >> testdata/employees.csv$ echo "3000,James,Fairview,Jul,15,1992" >> testdata/employees.csv

Using these two CSVs, we are going to:

• Remove the extra spaces on the first two lines of garbage.csv
• Remove the last character from each line in garbage.csv
• Change the case of each character to uppercase in the first two lines of garbage.csv
• Replace Bob with Robert in employees.csv ...