# Help filtering a rolled-up list **URL:** \ **Category:** Ask the Community\ **Created:** [December 14, 2020, 12:33am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109 "2020-12-14T00:33:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Sarah\_Arminta](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_arminta/32/18143_2.png) [@Sarah\_Arminta](https://connect.superhuman.com/u/Sarah_Arminta)\ **Post date:** [December 14, 2020, 12:33am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/1 "2020-12-14T00:33:49Z")
Hi! I’m having trouble with filtering a list of lists. I have 3 tables: - One with food products that lists the ingredients and nutrition facts for that food - Another with instances of each food, how much I ate, calculating the nutrition facts, logging the date eaten. - Last one which summarizes all the foods eaten in a day and totals the nutrition facts, shows the ingredients I ate that day, etc. What I’m trying to do is be able to filter the Daily Meal Tracking table by individual ingredients, so I can see all the days I ate foods with “Black Tea” for example. Or “Black Tea” and “Pasteurized Cream”. I’d also like to get rid of the blanks and consolidate duplicate ingredients (is there a way get unique values, not just count them? Hopefully the doc sharing below works, sorry I had to share my entire doc, because I have everything in one place: [https://coda.io/d/Sarah-Arminta\_djCQirrIfCZ](https://coda.io/d/Sarah-Arminta_djCQirrIfCZ) https://coda.io/embed/jCQirrIfCZ/_su0sx?viewMode=embedplay ---
**Author:** ![Breno\_Nunes](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/breno_nunes/32/12706_2.png) [@Breno\_Nunes](https://connect.superhuman.com/u/Breno_Nunes)\ **Post date:** [December 14, 2020, 1:46am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/2 "2020-12-14T01:46:30Z")
Hey, @Sarah_Arminta. I think this Doc bellow can help you: **[Playground Doc - Search with Regex](https://coda.io/d/Playground-Doc-SHARED_dOpFM0dnOXm/Search-with-Regex_su5YE#_luiZp)** And to get rid of the blanks, you should remove the .split() from your formulas. ---
**Author:** ![Sarah\_Arminta](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_arminta/32/18143_2.png) [@Sarah\_Arminta](https://connect.superhuman.com/u/Sarah_Arminta)\ **Post date:** [December 14, 2020, 2:06am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/3 "2020-12-14T02:06:49Z")
What a great resource! I was able to get the search working, thanks! But it’s ugly. I removed the split(), but now I still have undefined and empty lists mixed in with everything. Any ideas to clean things up? ---
**Author:** ![Sarah\_Arminta](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_arminta/32/18143_2.png) [@Sarah\_Arminta](https://connect.superhuman.com/u/Sarah_Arminta)\ **Post date:** [December 14, 2020, 2:48am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/4 "2020-12-14T02:48:05Z")
I was able to clean up the individual ingredient columns with some filters: `thisRow.[Foods Eaten].[Fruit Ingredients].Filter(CurrentValue.ToText() != "").ToText()` Then I cleaned up the full list with this: `Lower(thisRow.[Drink Ingredients]+","+thisRow.[Dairy Ingredients]+","+thisRow.[Fruit Ingredients]+","+thisRow.[Vegetable Ingredients]+","+thisRow.[Other Ingredients]+","+thisRow.[Spice/Sweetener Ingredients]+","+thisRow.[Meat Ingredients]).Unique().Split(",").filter(CurrentValue.IsNotBlank()).BulletedList()` And the search still works! Thanks for your help 😀 ---
**Author:** ![Breno\_Nunes](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/breno_nunes/32/12706_2.png) [@Breno\_Nunes](https://connect.superhuman.com/u/Breno_Nunes)\ **Post date:** [December 14, 2020, 3:31am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/5 "2020-12-14T03:31:42Z")
Hi, @Sarah_Arminta I redid your Doc in a way I usually do mine. Please, check if it makes any sense to you. > **[Untitled](https://coda.io/@breno-nunes/dailymealtracking)** https://coda.io/embed/r_efsXb_gS/_su8Ng?viewMode=embedplay ---
**Author:** ![Sarah\_Arminta](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_arminta/32/18143_2.png) [@Sarah\_Arminta](https://connect.superhuman.com/u/Sarah_Arminta)\ **Post date:** [December 14, 2020, 3:46am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/6 "2020-12-14T03:46:49Z")
Oooh, yeah I like it. Then you can filter with the control, nice! I think I’ll work on putting ingredients in their own table, like you have. Thanks for the example! 🙏 ---
**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\ **Post date:** [December 14, 2020, 3:04pm UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/7 "2020-12-14T15:04:39Z")
I published a doc with various search setups here if you want to copy it to see how they all work. [https://coda.io/@ben-at-coda/custom-table-search-solutions](https://coda.io/@ben-at-coda/custom-table-search-solutions) ---
**Author:** ![Sarah\_Arminta](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/sarah_arminta/32/18143_2.png) [@Sarah\_Arminta](https://connect.superhuman.com/u/Sarah_Arminta)\ **Post date:** [December 14, 2020, 6:32pm UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/8 "2020-12-14T18:32:52Z")
Awesome @Ben_Lee!! Thank you so much! 😀 ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [December 15, 2020, 11:05am UTC](https://connect.superhuman.com/t/help-filtering-a-rolled-up-list/20109/9 "2020-12-15T11:05:06Z")
hi @Ben_Lee, thanks for sharing this doc again. I had a look at the Regex() and at the Find() solution, but the only formula I could find on these pages is this one. ``` Lower(thisRow.Name+","+thisRow.Category+","+thisRow.Notes) ``` On both pages this is the same. I wonder how the Regex & Find solution work, can you elaborate on this (even in the doc)? Thanks!, Christiaan