You could use XML files too. As you move to VB.NET these XML files are very supported and easy to use.
Tim --- In [email protected], "HouseDad" <[EMAIL PROTECTED]> wrote: > > > > 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/
