PARSING question -delimiting files with something other than a comma 
Author Message
 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!



Sun, 25 Jul 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Functions to parse comma delimited file

2. HELP PARSING COMMA DELIMITED FILE INTO ARRAY

3. Parse Comma delimited file with exceptions

4. HELP PARSING COMMA DELIMITED FILE INTO ARRAY

5. Parsing a comma-delimited string

6. vba api parsing comma delimited data

7. Parse a comma delimited list from a database field

8. Parsing comma-delimited record

9. Importing comma delimited text file question

10. Converting a flat file to a comma delimited file

11. Convert comma-delimited file to DBF file??

12. Automating importing a text file (comma delimited) with VBA

 

 
Powered by phpBB® Forum Software