RegEx help

[Ruslan Zasukhin]

on 7/2/03 13:11, Wonder Fef at wonderfef at noos.fr wrote:

> Hello all,
> 
> I've read the RegEx documentation, but it's too hard for me, so I'm now
> asking for your help.
> 
> I've added a search engine to my application, but I'd like to add this
> feature :
> 
> For example:
> The user is searching for "M.G.M", if this record exists as "MGM", Valentina
> should find it.

    "M.G.M" -- you mean that user type DOTS ?
   and you want find MGM ?
   
Then you need first of all self correct user's input to "MGM"
And we get next task:

> In another way, if the user is searching for "MGM", if the record exist as
> "M.G.M", Valentina should find it

To do this you need query as

    WHERE fld LIKE 'M.*G.*M'

Here '.*' say that between M and G can be zero or any number of any chars.


> I know that there is a mean to tell RegEx to include one character wherever
> it is or it is not.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------