Extract Parts of a String

Replies to This Discussion

Permalink Reply by David Rutten on December 18, 2009 at 3:45am

I think you'll have to use VB or C#. I didn't wrap the Split() function in the expression language, since it returns an array of values, which is difficult to deal with in an Expression.

You can use one of the String.Split() overloads in the DotNET Framework if you decide to use VB or C#.

Note that splitting often works on an array of chars, rather than whole Strings. This is sometimes confusing and usually it means it's best to perform a few replacement operations prior to splitting:

myString = myString.Replace(")(", "|")
myString = myString.Replace("(", String.Empty)
myString = myString.Replace(")", String.Empty)

Dim parts As String() = myString.Split("|"c)
Dim numbers As New List(Of Integer)

For Each part As String in parts
Dim sub_parts As String() = part.Split(":")
For Each sub_part As String in sub_parts
numbers.Add(Integer.Parse(sub_part))
Next
Next


--
David Rutten
david@mcneel.com
Poprad, Slovakia

Permalink Reply by tim williams on December 18, 2009 at 4:17am

Thanks for the reply David.
I will try this out.