reverse filter function?
How do you do a reverse filter - like regular expression [^characters] (i.e. everything but) ?
For example, I tried:
Filter(Lower(fieldToFilter) ; not "u123456789") <> ""; 1; 0
But this did not work.
You could try this http://www.briandunning.com/cf/922
This is a pretty old thread but I think I have the right calculation if anyone out there is still wondering how to do this. I dont have filemaker installed on this computer so there is no way for me to know if this works 100% but here goes
~Result = Substitute(fieldToExtractText;textToExtract;"");
~Result = Substitute(~Result;" ";" ");
~Result = Trim(~Result)
The first line of code removes the text you want to extract from the text field by replacing it by ""
If entire words are extracted from a field this will leave a double space because of the space that was before the word and the space that was after the word. that is what the second line of code is for. It replaces " " with " ".
The third line of code gets rid of the leading space if the extracted text happened to be the first word or the last word in the text field.
There you have it. A reverse filter.
Retrieving data ...