I'm not to hot on regex, done a fair amount of googling but for some reason seem to be struggling on this. Basically I have a string as:
VALUE1,VALUE2,VALUE3,VALUE4
Now all want is a regex where I can say give me value 2 or give me value 3 etc.
I would have thought I could do something like this to get the 2nd value
,.*,,
This for last etc
,,,.*
There must be a simple solution to this...should also add this has to be done via regex!
I think all you need here is a regex split on the comma separator:
Dim input As String = "VALUE1,VALUE2,VALUE3,VALUE4"
Dim terms() As String = Regex.Split(input, ",\s*")
For Each term As String In terms
Console.WriteLine(term)
Next
Note that I split on ,\s*, in case there might be some whitespace after each comma.
We could try to give you a raw regex which could extract a term in a given position, but even that would require knowing which tool you are using, to know how to access a capture group. Since you're using VB.net, splitting the string using a regex is probably the way to go.
Edit:
From the comments, perhaps the following regex pattern is what you are looking for:
^(?:.*?,){3}(.*?)(?=,|$).*$
