Help with RegexDim pattern As String = "**BEGIN**'(.*?)','(.*?)','(.*?) (.*?)'>" Dim replacement As String = "'$1','$2','$3', '$4'" & vbCrLf Dim rgx As New Regex(pattern, RegexOptions.Singleline) content = rgx.Repla

Hello everyone. 
I have a string from a .cvs and need to make some changes to the way the data is.
Raw is like: 'DATE1,'blabla','name','email','phone','Scity','amount','yes','','DATE2','city','state','','13 Weeks','DATE3','Yes','facility ','0-15 miles','No','Yes','Yes','','Studio','No','','No','','','',''
Some of the field will go into my database quite nicely, some will not. 
How can I:
A) find the value for name, and separate it into 2 fields ('first', 'last')
i.e.
Dim pattern As String = "**BEGIN**'(.*?)','(.*?)','(.*?) (.*?)'>" Dim replacement As String = "'$1','$2','$3', '$4'" & vbCrLf Dim rgx As New Regex(pattern, RegexOptions.Singleline) content = rgx.Replace(content, replacement)
B) find a particular field, save it to a different string so that I can change it as needed, then put i ...