I have a shapefile containing a String Type Field called 'Class'. This field contains one or more integers separated by commas.
I want to create Rule-Based symbology matching only 2, 12, 1 respectively.
I've tried the following rules with no luck, for the string '1,2,12' each rule matches both 2 + 12 e.g.
Rule 1 -
'Class' LIKE %2%
Rule 2 -
I was thinking adding * before and after each integer when the field is being populated but that would make the field very long. Was hoping there would be a fix for this problem.