Forum Discussion
Count rows that match a certain string from a column
Hi, I want to count rows that contain a certain value from a long string in a column Table id meta 1 apples_abc_def 2 mangoes_abc_def Count rows where meta contains apples ...
- =calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)
=calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)