A field value returned from a DE lookupcontains a tab-delimited list of values.

To determine if a specific text string exists in a tab-delimited list of values, the BuildRowSetFromString AMPscript function is the most appropriate. This function splits the string into a rowset, making it easier to search for the specific text.

BuildRowSetFromString Function: This function converts a delimited string into a rowset, which can then be iterated over or searched using other AMPscript functions.

SET @values = "val1\tval2\tval3" SET @rowset = BuildRowSetFromString(@values, "\t") SET @rowCount = RowCount(@rowset) SET @found = "false" FOR @i = 1 TO @rowCount DO SET @row = Row(@rowset, @i) SET @value = Field(@row, 1) IF @value == "specificText" THEN SET @found = "true" /* exit the loop if found */ BREAK ENDIF NEXT @i