String manipulation

Franco1 · July 16th, 2008, 10:31 AM

I have a comma delimited flat file with data that needs to be sorted and placed in different files. The raw data has to be sorted on the 9th column that says either "Yesâ or âNoâ.
In the raw data, each record ends with a âZâ (zee in double quotation mark).
How do I read each record and move it to another notepad file if the 9th column meets the criterion using VB dot net - 2005? Is it even possible?
Below is a sample of the file (the first record begins where it says 11335 and the second record begins where it says 11340:

"11335","11","11 Letter","areth","2008-07-03 22:58:13","161052","62465","7250","YESâ, SUPERVISOR- John","70","","229","8.49","229","0.00","4.50","0. 00","BMCVRTF","kanet","WXFT00","PLXZS","OT","99999 ","UG","","(999) 999-9999","1-800-999-9999","","MR CASPER","Leslie Ave","Unity","BG","999 999","","229","22931.71","0.00","0.00","0.00","0.0 0",
"0.00","0.00","0.00","1399","","","","","","", "",
"","","","","","","","","","","","",
"","","Z""11340","11","11 Letter","agrms","2008-07-03 22:58:13","161052","62465","7250","NO",SUPERVISOR- MAy"70","","229","8.49","229","0.00","4.50","0.00" ,"BMCVRTF","kanet","WXFT00","PLXZS","OT","99999"," UG","","(999) 999-9999","1-800-999-9999","","MR CASPER","Leslie Ave","Unity","BG","999 999","","229","22931.71","0.00","0.00","0.00","0.0 0","0.00","0.00","0.00","1399","","","","","",""," ","","","","","","","","","","","","","","","Z "

BrianWren · July 16th, 2008, 12:53 PM

Can it really be so that the file has no Carriage Return, Line Feed or CRLF between these records?
How did you get a file like that?

You could start by reading the whole file into a string.

Then use InStr() to find "Z"". The returned value plus 2 will be the record, plus 3 will be the start of the next record.

You can copy all up to InStr() + 2 into a different string.

Then use OrigString = Mid(OrigString, Instr() + 3).

That will strip off the part you copied into a different string.

You could write each of these operations into a temp file to create an easier-to-handle file...

I really am interested in hearing the answer to my original question, above.