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
2
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....
2 Likes
TIMAI2
3
I just re-read and you wanted the indexes....
use these blocks in File2.GotText
(note: 1 off because of header row in csv)
