Highlighted

Combine a query of strings and then search

Participant ,
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?

Adobe Community Professional
Correct answer by BKBK | Adobe Community Professional

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

}

Views

422

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

Combine a query of strings and then search

Participant ,
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?

Adobe Community Professional
Correct answer by BKBK | Adobe Community Professional

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

}

Views

423

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
Jan 21, 2019 0
Adobe Community Professional ,
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
Reply
Loading...
Jan 21, 2019 1
Participant ,
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
Reply
Loading...
Jan 21, 2019 0
BKBK LATEST
Adobe Community Professional ,
Jan 21, 2019

Copy link to clipboard

Copied

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
Reply
Loading...
Jan 21, 2019 0