Splitting text from numbers.

[dajunka]

Is there a .split command that would allow me to separate numbers from text in a given string.

Mystring = "1234, this, is, text,5678"

Using the split command I would just like for

this
is
text

to be returned ignoring the numbers. Is this possible?

[HanneSThEGreaT]

Hello again!

You see, you having a need to discard the numbers throws a spanner in the works, but it is not too complicated

We first need to split the string - I have noticed that there is a comma separating each segment, so we can use the comma as a delimiter. Right, after the split, we would have to test whether or not that segment is numeric or not. If it isn't numeric, then we add it to the label for example :

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim MyString As String
        Dim arrSplit()
        MyString = "1234, this, is, text,5678"

        arrSplit = MyString.Split(",") 'Split at comma

        For i As Integer = 0 To arrSplit.Length - 1 ' loop through each segment
            If Not IsNumeric(arrSplit(i)) Then 'if it isn't numeric
                Label1.Text = Label1.Text & arrSplit(i) 'add to label
            End If
        Next
    End Sub

I hope it helps

[Alsvha]

Use Regular Expression to strip the numbers out of the text. If you need the numbers as well, you can just use different groups to capture them.

For example:

Dim Mystring As String = "1234, this, is, text,5678"
Dim regEx As New Regex("\d+")
Dim Mystring2 As String = regEx.Replace(Mystring, "")

Mystring2 will then contain ", this, is, text" and can be split and trimmed.

[dajunka]

Hi!

Thank you so much, that really helps, and written in a way that even a fool like me may understand.

As a point of interest, I have noticed this in some examples...

arrSplit = MyString.Split(","c) 'Split at comma

Could you tell me the meaning of the "C" after ","

Thank you.

[dajunka]

Use Regular Expression to strip the numbers out of the text. If you need the numbers as well, you can just use different groups to capture them.

For example:

Dim Mystring As String = "1234, this, is, text,5678"
Dim regEx As New Regex("\d+")
Dim Mystring2 As String = regEx.Replace(Mystring, "")

Mystring2 will then contain ", this, is, text" and can be split and trimmed.

Oooh, this one is going to take some thinking about.

[Alsvha]

Hi!

Thank you so much, that really helps, and written in a way that even a fool like me may understand.

As a point of interest, I have noticed this in some examples...

arrSplit = MyString.Split(","c) 'Split at comma

Could you tell me the meaning of the "C" after ","

Thank you.

The "c" IIRC means character and you do not really need it.

[HanneSThEGreaT]

Ah, Regex At the end of the day it would be the most "appropriate" way

I tend to avoid them, as my regex skills aren't very good

Good one Alsvha!