ASP/VBS Repeat Region with a split

Report · Jul 28, 2006

Hi,

Not sure if this is possible, I have a memofield that contains a data string
(e.g. name1, name2, name3, name4 .... name 30) I would like to represent the
data in a table so that each name is on a different row eg

Name1
Name2
Name3
Name4

etc

Name30

Is this possible ?

Thanks,

Report · Jul 31, 2006

Sure. The usual method would be to split the string into an array and loop.
<%
myValues = Split(myMemoField,",")
%>
<table>
<%
For Each Value In myValues
%>
<tr>
<td><%=Value%></td>
</tr>
<%
Next
%>
</table>

You can accomplish the same without looping, though.
<%
MyTable = Replace(myMemoField,",","</td></tr><tr><td>")
%>
<table>
<tr>
<td><%=MyTable</td>
</tr>
</table>

Obviously, the second method has better performance. Either way.

"Sanj" <webuser@mm.com> wrote in message
news:eaeh10$nod$1@forums.macromedia.com...
> Hi,
>
> Not sure if this is possible, I have a memofield that contains a data
> string (e.g. name1, name2, name3, name4 .... name 30) I would like to
> represent the data in a table so that each name is on a different row eg
>
> Name1
> Name2
> Name3
> Name4
>
> etc
>
> Name30
>
> Is this possible ?
>
> Thanks,
>
>
>