Display the comma separated value in new line using AMP Script

Question

I have a field in data extension which has a data with comma separated like 6QB902085, 7T2390GHG, I want to display the comma separated in new line. I found it in stack i tried to use AMP Script with below code on which theTestOutput is blank and i am getting rowcount as 1.

%%[
    Var @testString, @testOutput

    Set @testString = "6QB922085, 7T2311GHG"
    Set @testOutput = BuildRowsetFromString(@testString,",")

]%%

RowCount: %%=RowCount(@testOutput)=%%
TestOutput: %%=v(@testOutput)=%%

Answer 1

You are trying to get a rowset displayed as a string, when a rowset is more akin to a JSON. This is similar to using LookupRows(), etc. You will need to parse the data in order to display it.

See below code, which should provide you the two values.

%%[
    Var @testString, @stringRowset

    Set @testString = "6QB922085, 7T2311GHG"
    Set @stringRowset = BuildRowsetFromString(@testString,",")
]%%
RowCount: %%=RowCount(@stringRowset)=%%
<br /><br />
%%[
for @i = 1 to Rowcount(@stringRowset) do
Set @row = Row(@stringRowset, @i)
Set @value = Field(@row,1)
]%%
TestOutput: %%=v(@value)=%%<br />
%%[
next @i
]%%

OUTPUT:

RowCount: 2

TestOutput: 6QB902085
TestOutput: 7T2390GHG