Faulty REGEX search

[Ruslan Zasukhin]

On 10/3/08 5:19 PM, "jda" <jda at his.com> wrote:

Hi Jon,

> I'm constructing a REGEX search that looks through a varChar field
> for words on separate lines. The lines may begin with a Return or Tab
> character, and may end with a Return or simply be the end of the
> field. The following search (for "33") returns 81 records (should be
> none). If I remove the \0 (which should signify end-of-field) it
> returns none, which is correct.
> 
>       (varCharField REGEX '(?i)[\r\t]33\0')
> 
> I've looked online for REGEX instructions and found the $ can be used
> to indicate end-of-line. This search *seems* to work properly
> 
>       (varCharField REGEX '(?i)[\r\t]33$')
> 
> Is that in fact the correct syntax, or am I missing something?

As I remember MULTI-LINE regex search always is problematic.

Please search in Valentina WIKI for REGEX.
Some its page point to ICU docs page,
And read ICU docs about this.


-- 
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]