BuildRowSetFromString

Overview

Creates a rowset from a character string by splitting the string at the specified delimiter.

Syntax

BuildRowSetFromString(1, 2)

Function Properties

OrdinalTypeDescription
1stringRequiredValue used to create rowset
2stringRequiredCharacter used as delimiter, such as a comma.

Usage

Returns a rowset with three rows. However, this function returns the rowset in one column, and this column doesn't have an assigned name:

The sample code below demonstrates how to pass and process attribute names:

When passed the input below:

The AMPscript returns the following:

Because this function returns the rowset in one column, and this column does not have an assigned name, you refer to the column within a function using an ordinal number: