You are working as a system administrator and have been tasked with querying a CSV file using only the CLI (Command Line Interface). The file can be downloaded with the following command:
“`
curl -O -L https://github.com/linuxacademy/content-intro-to-databases-on-linux/raw/master/demo.csv
“`
Once the file is downloaded, you will query this file for the **Department** of the user with an ID of **3**, and the **Name** of the user with an ID of **2**.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Print the Row with an ID of 3
grep ^3 demo.csv
- Print Only the Department
grep ^3 demo.csv | awk -F, '{ print $3 }'
- Print the Row with an ID of 2
grep ^2 demo.csv
- Print Only the Name
grep ^2 demo.csv | awk -F, '{ print $2 }'