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.put fld "Data" of this card into tmpData filter tmpData with "*" & tab & "*" & tab & "*" & tab & myNumber & tab & "*"
I seem to remember an old thread where it was discovered that when you start looking at complex filters like this, a "repeat for each" loop ends up faster. Worth testing anyway. Cheers, Sarah _______________________________________________ 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
