REGEX question

[Ruslan Zasukhin]

On 7/9/06 7:37 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I'm trying to do a search on a VarCharField that will match file names.
> 
> The names are kept in a CR-delimited list that begins with a tab:
> 
> tab
> file1 return
> file2 return
> file3
> 
> I'm doing a REGEX search that should find ONLY complete matches. I
> can match the beginning, but so far can't find a pattern that matches
> the end. Here's what I have:
> 
> select * from theTable WHERE varCharField REGEX '(?i)[\t|\r]ruslan.pdf'

Why regex starts from \t  \r   ?

Note, regex always have issues if you want do multi-line search
 
> What do I need to add so that the last characters are at the end of the line?
> 
> Thanks,
> 
> Jon
> 
> P.S. I've tried $, \z, and \Z at the end of the query, but no success.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]