> For the complete documentation index, see [llms.txt](https://gchandra.gitbook.io/big-data-and-tools-with-nosql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gchandra.gitbook.io/big-data-and-tools-with-nosql/linux-and-tools/csvgrep.md).

# 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>