PROBLEM WITH MY REGEX IN IN-DATABASE FORMULA-IN DB

[jean_franck]

Hello everyone,

I am pretty new in Alterys,the problem i am facing now is about regular expression in IN-Database tool

i am using a regular expression in IN-FORMULA IN DB TOOL ,but at the end in the result i hae the new field as FALSE but looking at the mail  i can see that it is true,Really dont know why

`email`  like '^\w+([.\-_]\w+)*@[a-zA-Z0-9]+([.\-_]?[a-zA-Z0-9]+)*[.][a-zA-Z]{2,4}$'   in the IN-FORMULA-IN DB returning 

False --- toto@gmail.com

False --- toto_titi@live.fr

False --- tata12.tutu@hotmail.com

Hope i was clear in explaination my problem.

Thanks for your help.
                        

[AdamR_AYX]

What type of database are you running against and does it support regex?  I've not seen that syntax before.

[jean_franck]

The database is oracle,and this syntax is also proposed by alteryx but for the IN-MEMORY tool.

The thing is ,it does give me the correct mail but the bool returning me false .

Thanks for your reply

[AdamR_AYX]

So looking at this page

https://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_re.htm

It seems you might need REGEXP_LIKE instead of like?

[jean_franck]

I will check and come to you

[jean_franck]

Nothing works,regexp_like or regexp_match not recognize
After checking we are running hive in hadoop environment

[AdamR_AYX · Accepted solution]

I know even less Hive than I do Oracle :) , but this page

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

seems to imply the command is RLIKE on hive

[jean_franck]

Thanks to you i will go through and let you know

[jean_franck]

Hi AdamR,

The link helps me i found out the way to use my REGEX and make it work
I used REGEXP

EX: A REGEXP 'Regular Expression'

Thanks for your help