Problem filter list

[Sad_Cello]

Hello

I have a CSV file or I'm trying to make a filter:

Num;Name;Categorie
1;Beer Punch;Champagne
2;sunrise;Champagne
3;Tan;Champagne
4;Black;Café
5;Boulev;Café
6;Bourbon;Biere
7;Citrus Shandy;test
8;Honey Beer;test
9;IPA;Café
10;Shandy Radler;Café

I am looking to retrieve the index of each row or appears in the column "category" the word "Coffee".

I have to do it backwards because I have the first result that appears (4) but not the following ones.

the loop stops after finding the first line where the word "Coffee" appears

thank you in advance

[TIMAI2]

Problem is that your "csv" is not correctly formatted, using a ; as delimiter. Convert these to , to work with the csv as a list in AI2...

I used two File components to make it easier to see what is happening, you can use just one, if you set the conditions right

The blocks return a list of the items that contain "Café"

There are other ways to do this....

I see you also asked on Kodular - this just wastes people's time....

[TIMAI2]

I just re-read and you wanted the indexes....

use these blocks in File2.GotText

(note: 1 off because of header row in csv)