CSV items to multiline textbox in VB.NET

I am using Visual Studio 2008. I am trying to take a line of comma separated items and send them to a multiline textbox.  For example "1,2,3,4" would appear in the textbox as:


I would like to do this in a For Each or For Next statement.
Who is Participating?
RyanAndresConnect With a Mentor Commented:
This code allows you to manipulate each line. If this is not what you're looking for please provide a sample input and expected output.

Dim str As String = "1,2,3,4"
Dim lines As String() = str.Split(","c)
Dim output As New StringBuilder()
For Each line As String In lines
txtFirstName.Text = output.ToString()

Open in new window

Walter RitzelSenior Software EngineerCommented:
If you dont have the comma as a valid char for each value, you can try something like this:

Dim formatedValue as String

formatedValue = SourceCSVLine.Replace(",",CHR(13))

textBox.Text = formatedValue

Sorry for bad VB syntax... I'm C# guy....
The following code assigns each delimited part as a new line
string line = "1,2,3,4";
textBox.Text = line.Replace(',', '\n');

Open in new window

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Someone beat me and I forgot to convert to VB:
Dim line As String = "1,2,3,4"
textBox.Text = line.Replace(","c, ControlChars.Lf)

Open in new window

schwientekdAuthor Commented:
I modified your lines slightly by replacing CHR(13) with vbCrLf and that did accomplish the simple question I asked.  However I was looking for a way to do this with a For statement.  The reason is that the thing I am trying to accomplish is much more complex but I was trying to start small.  The comma separated items I am using are actually going to be codes that are stored in a table.  Each code will have another column with a description and the descriptions are what need to appear in my textbox. Sorry for the long explanation which I don't expect to be answered in this post but I just wanted to explain my reason for wanting to use a For statement.
Walter RitzelSenior Software EngineerCommented:
In this case, I think the last code from RyanAndres is what you are looking for.
schwientekdAuthor Commented:
I think that this will get me started.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.