Hi All. Am running IIS6 / .Net Framework / working in ASP.NET using Visual Basic.NET.
I have some "contacts" data imported from a CSV into an Access Database. The troublesome field is the "Phone" field as it contains text and numbers, for example "Office phone: 0234 132432Cell phone: 07865 99999". What I need to be able to do is extract the "office phone" number to a seperate "Office Phone" field, same for "Cell Phone" and I think there are some "Office Fax" numbers as well.
I have performed string manipulation before but am a bit stumped by this.
Any help would be gratefully recieved!