Get the nth element after filtering

[pluma9]

Given csv:

id,color
1,blue
2,green
3,yellow
4,yellow

I want to filter the yellow items and get the second one (i.e. the one with id 4).

I tried the following but it does not work:

mlr --icsv --opprint filter '$color == "yellow"' then filter 'FNR == 2' items.csv

I believe this is because FNR is the row number in the original item list.

How can I achieve this?

[aborruso]

A solution by verb could be this one:

mlr --csv cat -n -g color then filter '$color=="yellow" && $n==2' input.csv

In output you have

n,id,color
2,4,yellow

You can add cut -x -f n to remove n.

[aborruso]

Hi @pluma9 did you try it? Is it what you wanted?

[pluma9]

Hi @aborruso, it works like a charm. Thanks very much for your support!