Ok, I know it's "going backwards in time" but I have a simple
question which hopefully has a simple answer.
I process a lot of CSV format files. Currently, when I read the
data, I have problems when there's a COMMA in the middle of a field,
since the INPUT command treats it as a new field, even though it's
not delimited by QUOTES.
A few programs in the past I have gotten around this by reading
the file one character at a time and looking for the commas, then I
strip the quotes from the build string. To me, this is really
reinventing the wheel.
Most of the programs, I just use an INPUT statement like
aforementioned, then I pop up an error box showing the last good
record when an extra comma has caused the order of fields being read
to be altered.
For some reason, on a regular file opened for INPUT, I was
thinking I could use GET to read the field, but that doesn't work,
except for pre-defined fields in a RANDOM access statement.
A couple of ways I can get around this are re-writing the
programs to utilize ADO ( I am assuming ADO has no problem
recognizing that a comma in-between two quotes is part of the field),
reading the file one byte at a time, or reading the data from EXCEL.
Reading the data from EXCEL would work great except this
particular file I have to process has 200k records and EXCEL won't
load the whole thing. I know I could split it, but I am hoping there
is an easy way to read the data directly from the file.
I definitely plan on going ADO in the future but can't take the
time to do that right now in the middle of the project.
Any ideas?
[C]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
