# CSVGREP

-c column -m filter

`csvgrep -c Region -m Europe sales_100.csv`

**Using Regular expression to find Regions starting with A**

`csvgrep -c Region -r ^A. sales_100.csv`

**Combining Grep, Cut, and Look**

`csvgrep -c Region -m Europe sales_100.csv | csvcut -c 1,2 | csvlook`

**Inverse Matching**

`csvgrep -i -c Region -n region -m Europe sales_100.csv | csvlook`

### **Sorting data**

**Sorting on Region column**

`csvsort -c Region sales_100.csv | csvlook --max-rows 3`

**Sorting in Reverse Order on Region Column**

`csvsort -r -c Region sales_100.csv | csvlook --max-rows 3`

## &#x20;<a href="#sql-refresher" id="sql-refresher"></a>