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 ...
Go to the complete details ...