Data Transform - Looking for two specific pieces of text

Question

Jason Lewins · 14 hr ago

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"

Discussion (2)3

Enrico Parisi · 13 hr ago

Just add another "if" within the "else" block?

0 0

Jeffrey Drumm · 10 hr ago

Instead of ..Contains() as the outer method, use:

..RegexMatch(..ToUpper(source.{PIDgrpgrp(k1).ORCgrp(k2).OBXgrp(2).OBX:ObservationValue()}),"NOT DETECTED|NEGATIVE")

0 0