
PARSING question -delimiting files with something other than a comma
Anyone know how I might change the VB 4.0 default of reading a file
delimited by a comma to instead delimit records with a semicolon for
example?
I have a file I do not want to rewrite the incoming file since it is
another vendor's file output that I want to keep alone. I am parsing
the file and putting certain things into arrays that become parts of
combo list boxes that a user can select things from.
The problem occurs when I read past the end of the "real record" and on
into the next record. Each of the "real records are separated with a
semicolon. The real records also have commas though and hence I end up
reading several times (Input #1, meta$) until I find (Instr(meta$, ";")
Quote:
> 0).
Parsing is never pretty but I would like a better solution.
Thanks for anyone's two cents worth!