get substrings

[sirius]

Hi,
I have a delimited string containing various information. This is passed from a form. I need to extrract the indidual items before I insert them into a database.

How??

Thanks

[Bullschmidt]

Assuming the delimiter is the | character:

strarrayFormat = Split(pstrFormat, "|")

' Loop thru items.
' Start at 1 since 0 is just the format type.
For intItemNum = 1 To UBound(strarrayFormat)
Response.Write strarrayFormat(intItemNum)
Next