Data Transform - Looking for two specific pieces of text
Hi,
I have the following transform working but i also want to add another string of text for it to look for but i'm unsure of how to write this in. The two bits of text are "NOT DECTECTED" and "Negative"
.png)
Discussion (2)3
Comments
Just add another "if" within the "else" block?
Instead of ..Contains() as the outer method, use:
..RegexMatch(..ToUpper(source.{PIDgrpgrp(k1).ORCgrp(k2).OBXgrp(2).OBX:ObservationValue()}),"NOT DETECTED|NEGATIVE")