I am using textcount function for example the following table column. In first case when I need the text count of these values I am using this expression.
TextCount ({<String_Field={'string name 1', 'string name 2' }>}String_Field)
which is working fine. whereas in the second example. I need the rest of the values apart from these ones how can I modify the expression to get the values excluding these two because I don't want to mention all the values like the first expression. is there any way to use except or exclude.
| String_Field |
| string name 1 |
| string name 2 |
| String class 1 |
| String class 2 |
| 'String' class 3 |
| String class 4 |
| String class 5 |
| String class 6 |
| String class 7 |
| String class 8 |
which is working fine. whereas in the second example. I need the rest of the values apart from these ones how can I modify the expression to get the values excluding these two because I don't want to mention all the values like the first expression. is there any way to use except or exclude.
Also if I use the same expression I have a string that consists 'example' when I am trying to write the same expression I am getting error.
however I need the values except these. For example I want exclude these two values.
| string name 1 |
| string name 2 |
