Hi,
If a field (in my example it is 'Inception') containing numeric values has a letter somewhere in the value, is it possible to highlight the output cell Yellow? Currently, I have done this but no luck.
Thanks!
Solved! Go to Solution.
I think the following should do the trick:
REGEX_CountMatches([Inception], "[\D]") > 0
This will highlight everything with at least one instance of something that isn't a number in the field. If you need it to be specific to letters then you could use:
REGEX_CountMatches([Inception], "[a-zA-Z]") > 0
That's amazing, what about the other way round? So if a field containing letters has a number somewhere in the value
In the formula I provided previously, the \D capitalised indicates a non-number, so if you want to find where there ARE numbers, simply use the lowercase equivalent I.e. \d, which indicates the presence of a number in the field.
This is all great! However, I have blank cells in my data that will need to stay there but I don't want these highlighted Yellow (with the above formulas, they highlight them). Is there a way to not highlight blank cells?
If you want to leave empty cells out of the highlight then should just be able to add the following to your highlight condition:
AND !IsEmpty([Field Name])