I have a table where i need to validate strings. I am trying it with state definition but it is checking with the whole string and not considering the sub string. So, is there a way to validate string values using sub string in a grid.
Attaching an image of required output:
To my understanding, you'd like to validate only part of the string, correct? And then based on the validation result, change the color of the cell?
You may read the bottom part of this document in the helpcenter about data driven state definitions: