Combine a query of strings and then search

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?

This topic is closed to new replies. Start a new post to keep the conversation going.

BKBKCorrect answer

Community Expert

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");

}

Correct answer

Community Expert

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");

}

Translate

Inspiring

As always - thank you

Translate

Community Expert

My pleasure, weezerboy

Translate

Sign up