Combine a query of strings and then search

Participant ,
Jan 21, 2019 Jan 21, 2019

Copy link to clipboard

Copied

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?

Views

442

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Adobe Community Professional , Jan 21, 2019 Jan 21, 2019
weezerboy  wroteSo I need to combine these results into one string.
// Combine comma-delimited listcombinedList=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");}

Likes

Translate

Translate
Adobe Community Professional ,
Jan 21, 2019 Jan 21, 2019

Copy link to clipboard

Copied

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

}

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jan 21, 2019 Jan 21, 2019

Copy link to clipboard

Copied

As always - thank you

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jan 21, 2019 Jan 21, 2019

Copy link to clipboard

Copied

LATEST

My pleasure, weezerboy

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines