[Solved] Troubles understanding StdFilter [Range Functions]

[cornouws]

Hi *,

Using 2.3.1 / 2.4_dev

I'm working in a spreadsheet and working with the StandardFilter on some data. Example:
flour 12
filter 23
flower 15
folder 47

When using Data|Filter|StandardFilter and choosing Regular expressions, I'd expect that entering "fl." (with dot, but without quotes) in the field Value, would find flour en flower. Nope.
Anyone knowing what I'm doing wrong??

Thankx,
Cor

[Hagar Delest]

The period is valid for a single character.
Try with ".*"

Edit: So the filter should be fl.*

[huw]

To expand on Hagar's answer, fl. would match fly flo and flu

When you get time, have a read of Regular Expressions in Calc, and the Writer article it refers to.

[cornouws]

Thanks Huw and Hagar.
As in my other post, it's obvious that reg expr. are not suitable for a person with a rushing reading style, as I often do. I'll have to better my life