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.
Solved! Go to Solution.
What type of database are you running against and does it support regex? I've not seen that syntax before.
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
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?
I will check and come to you
Nothing works,regexp_like or regexp_match not recognize
After checking we are running hive in hadoop environment
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
Thanks to you i will go through and let you know
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