BuildRowSetFromString Function

The BuildRowSetFromString function allows you to create a rowset from a string and define the delimiter.

Example:

					

Item Number(s):

%%[ Set @queryparams = BuildRowsetFromString(‘12345,33333,99999’) for @i = 1 to Rowcount(@queryparams) do Set @row = Row(@queryparams, @i) Set @itemNumber = Field(@row,1) ]%% #%%=v(@itemNumber)=%%
%%[ next @i ]%%

Output:

Item Number(s): 
#12345
#33333
#99999

Explanation:

Using the string of items numbers in the example above, the BuildRowsetFromString creates a rowset similar to if we performed a LookupOrderedRows in a data extension. Then we used a For Loop to set the @itemNumber as a variable for each of those item numbers in the string. The output shows each of the item numbers in that string.

Leave a Reply

Your email address will not be published. Required fields are marked *