Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

jean_franck
6 - Meteoroid

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.
                        

8 REPLIES 8
AdamR_AYX
Alteryx Alumni (Retired)

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

Adam Riley
https://www.linkedin.com/in/adriley/
jean_franck
6 - Meteoroid

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
Alteryx Alumni (Retired)

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?

Adam Riley
https://www.linkedin.com/in/adriley/
jean_franck
6 - Meteoroid

I will check and come to you

jean_franck
6 - Meteoroid

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

AdamR_AYX
Alteryx Alumni (Retired)

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

Adam Riley
https://www.linkedin.com/in/adriley/
jean_franck
6 - Meteoroid

Thanks to you i will go through and let you know

jean_franck
6 - Meteoroid

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

Labels