Hello,
My table follows this structure:
| Name | Response |
| Alex |
[{"title":"hello, there","satisfaction":"true"},{"title":"response number 2","satisfaction":"true"},
{"title":"response number 3","satisfaction":"false"}]
|
| Alfred |
[{"title":"hello, there","satisfaction":"true"},{"title":"response number 2","satisfaction":"true"},
{"title":"response number 3","satisfaction":"true"},
{"title":"response number 4","satisfaction":"true"},
{"title":"response number 5","satisfaction":"true"}]
|
I would like to create a new column that counts the number of occurrences of the word "true" in the Response column for each row in my table.
My expected result would be something like this:
| Name | Response | Number of Occurrences |
| Alex |
[{"title":"hello, there","satisfaction":"true"},{"title":"response number 2","satisfaction":"true"},
{"title":"response number 3","satisfaction":"false"}]
| 2 |
| Alfred |
[{"title":"hello, there","satisfaction":"true"},{"title":"response number 2","satisfaction":"true"},
{"title":"response number 3","satisfaction":"true"},
{"title":"response number 4","satisfaction":"true"},
{"title":"response number 5","satisfaction":"true"}]
| 5 |
Can someone help me?
