Re: I love csv format


casioculture@xxxxxxxxx wrote:
Could make it with anything even bash' echo "$var1, $var2..." >>
filename. It' readable and even editable in vim or nano. It's easy to
parse and rearrange with awk. It loadable in gnumeric where i could run
statistical tests on it and visualise it in an instance.

I love it.

CSV is a very useful format but only if you know your data. There are
issues with, for example:
Data that can include the field separator.
Data that can include the record separator character.

There are ways around both the above but their is no CSV standard. If
someone was offereng to send you data in CSV format then you should ask
what program generated it and also ask for a sample.

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
quotes ;-)

- Paddy.

.

Relevant Pages

  • Re: I love csv format
    ... CSV is a very useful format but only if you know your data. ... 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)
  • Re: I love csv format
    ... 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)
  • 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: I love csv format
    ... It' readable and even editable in vim or nano. ... parse and rearrange with awk. ...
    (comp.programming)