Comma-delimited values

Paul D. DeRocco pderocco at ix.netcom.com
Mon Mar 8 13:03:01 EST 2010


> On 08/03/2010 19:44, Gregory Lypny wrote:
>
> I'm creating an app that imports comma-delimited tables.  A few
lines might look like this, where there are 14 items per line.
>
> "Mon, Jan 18 , 2010",9:14
AM,130557,4319,Trade,Buy,X,135,8.25,10,-82.5,1417.5,20,10
> "Mon, Jan 18 , 2010",9:14 AM,130558,4371,Accept,Your
ASK,X,135,8.25,10,82.5,1582.5,0,10
>
> My problem is that Rev treats each date in quotes as three
> items rather than one.  I convert the comma delimiters to tab by
> setting the itemDelimiter to comma and then running the lines
> through nested repeat-for-each loops as
>
> repeat for each line thisLine in dataTable
> repeat for each item thisItem in thisLine
> put thisItem&  tab after newLine
> end repeat
> -- more stuff here
> end repeat
>
> I end up with
>
> "Mon	(as the first item)
> Jan 18	(as the second)
> 2010"	(as the third)
>
> Any suggestions as how I might get the date treated as one item?

Add an inQuotes flag, with an initial value of false. For each item, if it
has a quote in it, toggle the inQuotes flag. Then, if inQuotes is set,
append a comma instead of a tab, to put the item back together again.

--

Ciao,               Paul D. DeRocco
Paul                mailto:pderocco at ix.netcom.com




More information about the use-livecode mailing list