Working with csv files that are 5000 lines or more

[Mark Smith]

Jim, try

on mouseUp
   set cursor to watch
   put cd fld "test" into tempvar
   set the itemDel to tab
   put 0 into addvar
   put 0 into counter
   repeat for each line L in tempvar
       add 1 to counter
       if item 15 of L is "FL" then
           add 1 to addvar --simple test for speed
           put counter & comma after matchedLines
       end if
   end repeat
   answer "addvar"
end mouseUp


Best,

Mark

On 10 Apr 2008, at 01:57, Jim Schaubeck wrote:

> Ian,
> Here's the script:
>
> on mouseUp
>   set cursor to watch
>   put cd fld "test" into tempvar
>   set the itemDel to tab
>   put 0 into addvar
>   repeat with x = 2 to the number of lines in tempvar
>     if item 15 of line x of tempvar is "FL" then add 1 to addvar-- 
> simple test for speed
>   end repeat
>   answer "addvar"
> end mouseUp
>
> There are 5500 lines in tempvar with 60 or so items in each row.   
> the data starts out in cd fld "test" but that put into tempvar is  
> very quick.
>
> Jim...
>
>
> On Wednesday, April 09, 2008, at 05:51PM, "Ian Wood"  
> <revlist at azurevision.co.uk> wrote:
>>
>> On 10 Apr 2008, at 01:35, Jim Schaubeck wrote:
>>
>>> When I search the data in tempvar, the repeat command works quickly
>>> for the first 1000 lines or so then things slow down dramatically.
>>
>> How are you doing the repeat? I'm just wondering if you've somehow  
>> got
>> code in there that is going through the previous lines, therefore
>> getting slower and slower as it goes through the process.
>>
>> Ian
>> _______________________________________________
>> 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
>>
>>
> _______________________________________________
> 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