Skip to main content
Nintex Community Menu Bar

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

  • February 14, 2017
  • 2 replies
  • 56 views
Forum|alt.badge.img+9

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.

    2 replies

    Forum|alt.badge.img+10
    • sojanm
    • February 15, 2017

    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.

    Forum|alt.badge.img+9
    • sonisick
    • Author
    • February 15, 2017

    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.

    198938_pastedImage_2.png

    This is the expression:

    198939_pastedImage_3.png

    I thought a view of my output based on a RunIf on MatchFound (Yes/No Variable) might be interesting:

    198928_pastedImage_1.png

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement