[RESOLVED] [2008] Splitting a String with a variable delimiter

[Voyto]

Hello. Really been struggling with this one, and i cant seem to find a simple method of doing it...surely there must be one? I have a list of values that i am loading into a variable. I am trying to split that variable by the whitespace that separates each value...the only thing is the whitespace varies in size. eg...

value 1_______________value 2____value 3
value 4__value5____________value6

is there any way of splitting by batches of whitespace?

Thank you

[Bulldog]

You could substitute the delimiter out so you only have one and then split the string. You can also do this;

        Dim s As String = "value 1_______________value 2____value 3"
        Dim split As Char() = {"_"c}
        Dim splits() As String = s.Split(split, System.StringSplitOptions.RemoveEmptyEntries)
        For Each str As String In splits
            MessageBox.Show(str)
        Next

[user name]

You could use LINQ for that.

Example.

Dim value As String = "1               value2    value3"
        
        Dim list = From s In value.Split(" "c) _
                     Where s.Length > 0

[Voyto]

You could substitute the delimiter out so you only have one and then split the string. You can also do this;

        Dim s As String = "value 1_______________value 2____value 3"
        Dim split As Char() = {"_"c}
        Dim splits() As String = s.Split(split, System.StringSplitOptions.RemoveEmptyEntries)
        For Each str As String In splits
            MessageBox.Show(str)
        Next

Fantastic, that worked a charm. Thank you!!