String Values Scoring
Another cool article description
You may also score a text / enum columns. Here you will have three outcomes high, medium and low:
For each outcome you may select options like:
- Any of the values you have in the selected columns
- Empty (no value) - if a value of the evaluated cell will be empty
- Anything else - a default option that will trigger if no match could be found
Scoring based on substrings / occurance
You can also match a high/medium/low score based on the substring or partial match of the string, for that purpose you can use following wildcards in your scoring criteria:
- Wildcards (
*) like*fooorfoo*
- Negation (
'!a/*foo','*!(b)foo')
- POSIX character classes like (
[[:alpha:][:digit:]])
- brace expansion (
foo-{1..5},bar-{a,b,c})
- regex character classes (
foo-[1-5])
- regex logical "or" (
foo/(abc|xyz)bar)
For example if your good criteria will be test* following string values will match:
- test123
- TesT
- Test;other;value
And following will not
- othertest
- one,two,test
- other;value;test
So if you want to match any occurrence of test you need to use two wildcards like *test*
Did this answer your question?
😞
😐
🤩
Last updated on April 8, 2024