Combine a query of strings and then search

[weezerboy]

I have a query that returns results like this

Row 1 -C,HU,NU,PO, CY, CAB

Row 2 - A,AB,AB,ABC,TY,GYU 

So I need to combine these results into one string and then see if the string 'CAB' is in the new combined string.

If it is, then output Yes

How do I do this easily?

[BKBK · Accepted solution]

weezerboy  wrote

So I need to combine these results into one string.

// Combine comma-delimited list

combinedList=listAppend(list1,string2);

... see if the string 'CAB' is in the new combined string.

If it is, then output Yes

if (listFindNoCase(combinedList, "CAB") gt 0) {

   writeoutput("Yes");

}

[weezerboy]

As always - thank you

[BKBK]

My pleasure, weezerboy​