Query This CSV File on Linux

15 minutes
  • 4 Learning Objectives

About this Hands-on Lab

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 }'

Additional Resources

To accomplish this you will need to complete the following steps:

  1. Print the row having an ID of 3.
  2. Print the third column of the matched row. This is the Department.
  3. Print the row having an ID of 2.
  4. Print the second column of the matched row. This is the Name.

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?