How do you query for a string in a multiline text box in a workflow?

I seem to be having difficulty searching for text in multiline text box in a workflow. I am manually populating a column based on items from another child list. I decided to write "NO DATA" into the Status Field, also multiline, when no transactions were present in the detail list. I'd like to be able to query that textbox for the existence of "NO DATA" but my queries don't seem to identify any of the lines.

I've tried a couple of things in the selection such as "equal to" and "NO DATA" also "begins with" since it's the only thing in the text box.

Page 1 / 1

You can use regular expression control , check match, In pattern try NO DATA, and the input text is the multi-line, it will return true if exists.

That worked.

I've actually set up a flag anyway because I had to go through a foreach loop and do a regular expression. I want to be able to get my results from a Query. Also just finding "NO DATA" is really not all I want to know. I want to make sure that there really isn't other data in the Multiline Field and I can't think of an expression.