Replacing LIKE with REGEX doubts

Stan Busk maxprog at mac.com
Thu Nov 24 17:11:09 CST 2005


Hi,

Just wondering some of the Valentina v1 LIKE equivalents using v2  
REGEX of

     Is equal to: myField LIKE '\Amytext\Z' no_case
Is not equal to: myField NOT LIKE '\Amytext\Z' no_case
        Contains: myField LIKE 'mytext' no_case
Doesn't contain: myField NOT LIKE 'mytext' no_case
     Starts with: myField LIKE '\Amytext' no_case
       Ends with: myField LIKE 'mytext\Z' no_case


are they?:


     Is equal to: myField REGEX '(?i)mytext'
Is not equal to: ???
        Contains: myField REGEX '(?i)[a-zA-Z0-9]+mytext[a-zA-Z0-9]+'
Doesn't contain: ???
     Starts with: myField REGEX '(?i)[a-zA-Z0-9]+mytext'
       Ends with: myField REGEX '(?i)mytext[a-zA-Z0-9]+'

If I am right with [a-zA-Z0-9]+ is there something better and wider?  
I mean that could consider more possible characters?

TIA,
~/Stan


More information about the Valentina mailing list