Re: splitting field by comma

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Spencer (kspencer_at_takempis.com)
Date: 05/19/04


Date: Wed, 19 May 2004 12:28:57 -0400

Dim SomeString As String = Replace(SomeOtherString, ",", VbCrLf)

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Paola" <anonymous@discussions.microsoft.com> wrote in message
news:51BF99E2-0F10-432C-880F-312A41C0B06B@microsoft.com...
> I have a field that I would like to split by commas. Does anyone know how
I can do this either by t-sql or vb? The ideal is for the detail.aspx page
to line break on each comma in the field. Please help!
>
> Paola

Quantcast