Working with csv files that are 5000 lines or more

[Jim Schaubeck]

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
>
>