Regex Match

[Shamaila.Yousaf]

Hi,

 

The rule works for the regex match in the subject but not in the body...everything looks right so not sure why this is 'failing'.

Any assistance would be great.

 

Regards

Sxx

 

[Steve Giller]

@Shamaila.Yousaf I think it's just that the comma between body and the apostrophe is missing.

[Shamaila.Yousaf]

Thanks, copied and pasted from the other rule, changed subject to body....still failing!

The Update request does work...

[James Ainsworth]

Hi Shamaila,

Could you copy and paste your latest regex expression and paste here as text (not a screen shot)?

[Shamaila.Yousaf]

Thanks @James Ainsworth

 

REGEX_MATCH(body, '.*\b[a-zA-Z]{2}[0-9]{8}\b.*') AND (toAddress LIKE "%ITCallLogging@derby-college.ac.uk%" OR toAddress LIKE '%ITServicesCallLogging@derby-college.ac.uk%')

[James Ainsworth]

Sorry... a couple more questions Shamaila.  When you say "failing" what precisely is happening? Is it just not picking up the email when you expect it to, or are you getting some form of error message?

Does the email that you are expecting to be picked up, get picked up by another rule at any point?

 

[Shamaila.Yousaf]

Apologies for the delayed response @James Ainsworth.

The rule fails so email remains in the inbox, this rule is number 2; the rule previous to this one is regex match on the subject line so not getting overruled by rule number 1.

 

Thanks

Sxx

[Shamaila.Yousaf]

@James Ainsworth did you kindly manage to get chance to take a look at this one for me?

I appreciate everyone is busy:)

 

Regards

 

Sxx

[HHH]

Can the "%ITCallLogging@derby-college.ac.uk%" surrounded by double quotes cause this? 

Also, is it case sensitive?
if so try (lower(toAddress) LIKE '%itcalllogging@derby-college.ac.uk%' OR lower(toAddress) LIKE '%itservicescalllogging@derby-college.ac.uk%')

[Shamaila.Yousaf]

Thanks @HHH that worked a treat, this will reduce my team having to manually apply the update to the request as well as allowing the call owner to pick up the updates as soon as the email is received! A massive thanks!

 

Sxx

 

This worked!

REGEX_MATCH(body, '.*\b[a-zA-Z]{2}[0-9]{8}\b.*') AND (lower(toAddress) LIKE '%itcalllogging@derby-college.ac.uk%' OR (lower(toAddress) LIKE '%ITServicesCallLogging@derby-college.ac.uk%')

[Shamaila.Yousaf]

My mistake...that test failed...

[HHH]

20 hours ago, Shamaila.Yousaf said:

My mistake...that test failed...

Error is in OR (lower(toAddress) LIKE '%ITServicesCallLogging@derby-college.ac.uk%')

%ITServicesCallLogging@derby-college.ac.uk% must be all lower case or test will fail

[Shamaila.Yousaf]

I have re-tried as you advised correctly and the rule is still failing.  I will arrange to have someone from the Hornbill team assist me in my next session with them.  Thanks for your continued support on this @HHH.

 

Regards

Sxx

 

REGEX_MATCH(body, '.*\b[a-zA-Z]{2}[0-9]{8}\b.*') AND (lower(toAddress) LIKE '%itcalllogging@derby-college.ac.uk%' OR (lower(toAddress) LIKE '%Itservicescalllogging@derby-college.ac.uk%')

[James Ainsworth]

Shamaila,

If this is an issue with case sensitivity, you still have a capital in your last email address.