Which is the best way to filter a database?

Let's say I want only users from X country, since there is a lot of data, how can I extract a list and only keep users of certain country? Can it be done with excel or is there any good tool?

If there is lots of data use terminal. Excel will break.

Not sure what data you have, but if it's a csv format you can use grep:

grep "Argentina" your_source_file.csv 

It will look for lines that have a specified "string" and then output the full line.

(November 22, 2022, 04:25 PM)fraserrgb Wrote: If there is lots of data use terminal. Excel will break.

Not sure what data you have, but if it's a csv format you can use grep:

grep "Argentina" your_source_file.csv 

It will look for lines that have a specified "string" and then output the full line.

Vouch for this right here, good and simple advice.