Split space delimited string with text qualifiers.
Posted on 2004-08-10
Using VB.Net in Visual Studio 2003
I have a string (originates from a text file) that I'd need to split, into an array or seperate variables, it doesn't really matter.
The problem is, it's space delimited, and has double-quotes for text qualifiers round the text fileds.
"C" "01" "90000014" 1997 15/04/97 "D/D PAYMENT" "Mr John Smith" 47.58 11/04/97
The above example has 9 fields. As you can see, the text fields have double-quotes round them, number & date fields do not.
I've searched and found a couple of routines, but none seem to work correctly with what I have.
Any ideas welcome.