Filter GSheet Data

[Linux_01]

Hello Team,

I want to filter out rows which are starting with any of the strings such as "Yes | yes | y | Y" from a GSheet and have a new GSheet with the filtered data.

Is it achievable using gam command?

Thank you.

Regards,

Linux_01

[Brian Kim]

This is probably better handled with Macro/Apps Script.

https://www.benlcollins.com/spreadsheets/google-sheets-macros/

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#copy(String)

[Simon Laycock]

Or even just a Query function.

[Kim Nilsson]

AFAIK, it's currently not possible in gam.

The problem with your request, is that the gam spreadsheets commands wants the data to be in JSON format, which it usually isn't when you pull it from a sheet, or a local file.

https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Spreadsheets#examples-1

I've talked to Ross about this a few times, and it's still on a longtime todo-maybe-never list. :-)

IF you could just download the rows in csv format to a local csv, and use csv...row_filter, then you could push that as a regular file upload to Drive.

When you then open the file in Drive it will be converted to a Sheets file.

gam create drivefile drivefilename "GoogleFile.csv" localfile "LocalFile.csv"

https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Drive-Files-Manage#create-files

BUT, you can't. Any use of the current spreadsheet command will render your data in the LocalFile.csv in a single row in either JSON format or columns.

Both useless to my brain.

Also, afaik, there's no query when printing the data from a sheet, so you can't filter it.

So, pulling only some data from a sheet and pushing to another sheet isn't possible with gam.

Easiest (and most powerful) way is to use a manual IMPORTRANGE with a QUERY in your Spreadsheet2.

You can also use a filter, maybe after an importrange. Like this.

https://webapps.stackexchange.com/a/98889/254842

[Gabriel Clifton]

In Sheets, for various filters like that, I use VLOOKUP. Very handy formula.