Re: CSV files

From: Mark Broadbent (no-spam-please_at_no-spam-please.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 19:24:16 +0100

no but next time I need to parse a csv I shall certainly look into it.
Cheers. 

-- 
-- 
Br,
Mark Broadbent
mcdba , mcse+i
=============
"Konrad L. M. Rudolph" <konrad_rudolph@madrat.net> wrote in message
news:%23MwDlqQOEHA.3420@TK2MSFTNGP11.phx.gbl...
> Mark Broadbent wrote:
> > I see. :(
> > You could potentially split on commas (refer to code sample) and for
each
> > string in string array returned split again on " queuing it all up and
then
> > combining it all together. Dont know how much error checking youd need
but
> > obviously it would still be a requirement.
>
> I don't want to interrupt ...
>
> but has either of you considered using regex to parse CSV?
>
> -- 
> Konrad -
> http://madrat.net/

Relevant Pages

  • Re: Fastest way to read data to populate combo controls?
    ... dumping the whole thing into a CSV and parse it using VB. ... When you talk about using a CSV, Ralph, I have no clue how VB would ... The Excel macro creates a Word document with six tables: ... If bPath Then ...
    (microsoft.public.vb.general.discussion)
  • Re: parsing a dbIII file
    ... I have to parse a file whose stucture look like ... If the format is similar to Excel's CSV format then the csv module from Python's standard library may well be what you want. ... I am not sure whether the pipe bars actually appear in your data file, so it is difficult to know quite exactly what to suggest, but I would play with the file in an interactive interpreter session first to see whether csv can do the job. ...
    (comp.lang.python)
  • Re: CSV files
    ... "Konrad L. M. Rudolph" wrote in message ... > but has either of you considered using regex to parse CSV? ... I did consider regex but if you read the posting on this thread by Daniel O' ... regular expressions however, so if you have any example code please post it. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Fastest way to read data to populate combo controls?
    ... dumping the whole thing into a CSV and parse it using VB. ... When you talk about using a CSV, Ralph, I have no clue how VB would ... The Excel macro creates a Word document with six tables: ... "How To Use ADO with Excel Data from Visual Basic or VBA"http://support.microsoft.com/kb/257819 ...
    (microsoft.public.vb.general.discussion)
  • Re: I love csv format
    ... Data that can include the record separator character. ... There are ways around both the above but their is no CSV standard. ... It is not as simple, for example, to parse a CSV file generated by ... Excel in AWK if text fields can include newlines, or commas, or double ...
    (comp.programming)