Re: A CSV or a LIST aggregate function

From: Brian Rice (mail_at_brianrice.com)
Date: 10/05/04 

Date: 5 Oct 2004 12:46:00 -0700

> The problem is that it wouldn't have a universal purpose. Comma
> separated values is probably one of the weakest possible choices
> of delimiters because there are so many cases where commas might
> be embedded in character fields.

Of course comma seperated values can look like this:

12, '1 2', '12,23', '12''34'

and therefore handle all kinds of embedded stuff.

Also... I figured comma delimited list would tie into (potentially)
the IN clause where a comma seperated list is used.

Relevant Pages

  • Re: Extract Last and First Names
    ... Funny I know I've checked multiple boxes TAB and comma, ... delimiters that the wizard actually checkmarked the consecutive ... >>> Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro Creation for name formating
    ... and than play with Data> Text to Columns ... You may need to make sure that you have empty columns ... you can set it for tab, comma, space, and other delimiters. ...
    (microsoft.public.excel.programming)
  • Re: Listbox, additem, changing delimiters
    ... Is 56 Frederick Street / Edinburgh all included in!Address? ... > comma or semi-colon but if I do the columns in the list ... It is the delimiters in strTemp that I wish to ...
    (microsoft.public.access.formscoding)
  • Re: Extract Last and First Names
    ... use a comma and trimall and just adjust manually for the corny names ... > delimiters that the wizard actually checkmarked the consecutive ... > "Peo Sjoblom" wrote in message ...
    (microsoft.public.excel.worksheet.functions)
  • Re: text file for mail merge stumped
    ... is headerr record delimiters. ... Here is my last attempt at macro recording. ... similar in header seperator setting. ... When bringing data in it does not reconize comma seperators. ...
    (microsoft.public.word.vba.beginners)
Loading