I want to apply a filter to a code field on a table, where characters 8 to 12 of the code field are a specific value. Is this possible with SETFILTER? If not, is there another way? Cheers, Andy
Try smth like this SETFILTER(YourCodeField,’???A???B’); where A and B are your special symbols. I try it in 3.70, it works.
Yes that’s exactly what I want! Many thanks! It works on 3.01B as well, it’s just that the ? symbol is not documented in the online help . . . . . . . Andy
quote:
…it’s just that the ? symbol is not documented in the online help . . . . . . .
Not quite correct - if you activate help and search for “filter”, you’ll find a topic called “Entering Criteria in Filters” The “?” worked in the Financials-versions - and with the old DOS-command DIR as well - so it is old…