colin_murray wrote:
>
> Hello,
> I had a question about Open Office Calc.
>
> I was using autofilter and wanted to do a standard filter for only entries
> that "contained" a
> certain word and that "did not contain" a certain word. I could not find
> these phrases in the
> Filter Criteria condition menu.
>
> Is it still possible to do what I wanted to do but just a different way? I
> know MS Excel
> autofilter allows for making a custom selection that does have
> "contain/ does not contain" options among others.
>
> Sincerely,
> Colin
>
>
I hope someone else replies. You may be able to use "regular expressions"
to your advantage. This website deals with that subject:
http://www.regular-expressions.info/ Help, FWIW, under "Regular
Expressions, list of".
The use of regex in OpenOffice is complicated by the fact that the
openoffice.org code writers have made their own rules and broken them. Help
is not entirely accurate. Here's a brief synopsis from a skilled user
writing on oooforum.org:
- - - - quote - - - -
Use Standard-Filter with regex-option.
The criterion for "starts with foo" is: ^foo.*
The criterion for "ends with foo" is: .*foo$
The criterion for "contains foo" is: .*foo.*
Regex-criteria can be used with operators equal (=) and and unequal(<>)
Short regex-howto:
- Use .* instead of *
- Use . instead of ?
- ^ means start
- $ means end
- if you search for a literal * escape it with \*
- same with any kind of braces and any of ^$.*?\&
- in doubt escape anything but <, > and alphanumerics, since \<, \>, \n, \t
and \C have a special meaning in regexes.
- avoid named character-classes as they are described in help (eg.
[:digit:])
Support of named classes is buggy and will change in future.
http://www.openoffice.org/issues/show_bug.cgi?id=64368
- - - end quote - - -
I suspect you will find it difficult. I've tried the "contains" (just as an
experiment) and failed. You may have to search far and wide and juggle all
the titbits you can find together until you get something that works. If it
gets too time-consuming, you could use companion columns containing formulas
using the functions FIND (or SEARCH) combined with ISNUMBER.
Regex does NOT work in Calc even as well as it works in Writer. At best,
it's a mess.
After those encouraging words, good luck.
--
View this message in context:
http://www.nabble.com/Calc-filter-tf3218315.html#a8942787
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
