filter with a tab character

[FlexibleLearning.com]

Thanks for the insights. Much appreciated.

The list to filter is not enormous, but the 'for each' option would also
handle any numeric evaluations, so both solutions will be valuable.

Hugh Senior
FLCo



Klaus wrote:
> Am 04.02.2013 um 18:04 schrieb FlexibleLearning.com:
>
>> I have tab-delimited list and am trying to filter lines.
>>
>> Q1. How do we include a TAB character in the expression? Using filter
with
>> "*\tsomeText" fails.
>
> use the contant TAB:
> ...
> filter tList with ("*" & TAB & "whatever")

Richard wrote:
>While the filter command is seductively simple to use, if your rows have
>many columns and you're filtering on one several columns in, you may
>find "repeat for each" will be more efficient:
>
><http://article.gmane.org/gmane.comp.ide.revolution.user/72192/match=filter
+tab+gaskin>