Sorry, I forgot an essential line...

function quickSortAndFilter theData,theItemNr,theFilter
  set the itemDel to tab
  sort theData by (item theItemNr of theData is not theFilter)
  repeat for each line myLine in theData
    if item theItemNr of myLine is theFilter then
      put myLine & cr after myNewData
    else
      exit repeat
    end if
  end repeat
  return myNewData
end quickSortAndFilter

Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http;//www.salery.com

Quickly extract data from your HyperCard stacks with DIFfersifier. http://differsifier.economy-x-talk.com




Op 16-jul-2007, om 17:58 heeft Gregory Lypny het volgende geschreven:

Hello Everyone,

I'm struggling with the filter command. I have tab-delimited data in a field, where each row has at least 56 columns. I want to filter the data based on a chosen number in that fourth column, for example, to return all lines that have a 9 there. The fourth column only contains a number from 1 to 10. The following handler works most of the time. I put three wild card expressions, lone asterisks separated by tabs, to make sure nothing is being picked up in the first three columns. The tab and asterisk (and it could be just an *) following myNumber says that it doesn't matter what is in the columns after the fourth.
<snip>
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to