Comma-delimited values

[Fredrik Andersson]

Hi,

I'd do it something like this (since I love using set itemdel...):

repeat for each line thisLine in dataTable
     set the itemdel to quote
     put the second item of thisLine & tab into newLine -- should be the 
date
     put the third item of thisLine into thisLine -- should be the rest
     set the itemdel to comma
     repeat for each item thisItem in thisLine
         put thisItem & tab after newLine
     end repeat

     -- more stuff here

end repeat

Cheers,

Fredrik

Gregory Lypny skrev 2010-03-08 18.44:
> Hello everyone,
>
> 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?
>
> Regards,
>
> 	Gregory
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>