At 12:52 13/08/2001 -0700, Bernie Corrigan wrote:
Bernie
No that's recent. I am talking about the days of the ICL 1900, I guess
about 20 years ago.
Ian
>Ian -
>
> Not so. There is no apparent ANSI standard for CSV (comma separated
>values) which can be found on their web site. I would suggest you look at
>the antique article (9/28/95)
>
>http://www.ansi.org/public/iisp/std_need/need24.html
>
>Which begins: "The need exists for document delivery functions to allow
>exchange of information between government, scientific data, business
>information, medicine, standards development, and national security
>management electronic publishing applications. Without this standard, the
>application-to-application interface (AAI) is not defined and publicly
>available for the national and global information infrastructure (NII/GII)."
>
>CSV is specifically listed as one of the items for which a standard is
>needed. A search of the ANSI web site under several topics turned up no CSV
>standard. If you can find the ANSI definition please let me/us know how to
>get to it.
>
>Bernie
>=======================================
>At 06:57 PM 8/13/2001 +0000, you wrote:
> >At 23:51 12/08/2001 -0700, Bernie Corrigan wrote:
> >
> >Bernie
> >
> >I don't think so. I thought ANSI/BSI declared a standard yonks ago which
> >R:base follows. ie
> >
> >Columns separated by the declared separator, coma being the default.
> >
> >Text data types enclosed in the declared quotes, this includes datetime
> >types. If their is a quote in the string another is added adjacent to it.
> >
> >Ian
> >
> >> It looks like the rules RBase follows for producing a CSV file
> are:
> >>
> >>Separate column/cell values with commas.
> >>
> >>and
> >>
> >>If the column/cell value contains only a comma then surround the
> column/cell
> >>value with quotes.
> >>
> >>If the column/cell value contains quote marks then don't do anything.
> >>
> >>If the column/cell value contains both comma(s) and quote marks then
> >>surround the column/cell with quotes and place doubled quote marks in place
> >>of each of the original quote marks.
> >>
> >>
> >>Bernie
> >
> >
> >
> >
