Parse string from field CORRECT EMAIL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Somdahl - 19 Apr 2007 19:36 GMT

Hi, I am new to ASP but have what should be a fairly simple task that I
can't figure out.
I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)

I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on

I'm using ASP, VB Script with DMSII Database and OLEDB

Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?

Reply to this Message

Evertjan. - 19 Apr 2007 22:04 GMT

Dan Somdahl wrote on 19 apr 2007 in microsoft.public.inetserver.asp.db:

> Re: Parse string from field CORRECT EMAIL

Email? This is usenet, not email!

> Hi, I am new to ASP but have what should be a fairly simple task that
> I can't figure out.
[quoted text clipped - 6 lines]
> string in one cell. I need to break that string apart and put each
> semi-colon delimited value in it's own cell.

<% 'vbs
myArr = split(myStr,";")
%>

....
<td><%= myArr(0)%></td>

<td><%= myArr(1)%></td>

<td><%= myArr(2)%></td>
....

or use a loop

> Then move to the next
> record and do the same thing in the next row of the table. - and so
[quoted text clipped - 4 lines]
> Does anyone have some code examples on how to break this field apart
> and then arrange the data into an html table on a webpage?

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Reply to this Message

Webmaster Forum / ASP / Database Access / April 2007

Parse string from field CORRECT EMAIL