Email routing rule assistance with using body of email for routing rule criteria

[Adam Toms]

Hi, 

I may be reaching a limitation of what can be achieved using email routing rules, or may be a limitation of my knowledge, but I need to define a blank onboarding record. Unfortunately it seems that we cannot achieve this via the subject, as although it's a blank form it still seems to contain the name of the person onboarding, and therefore each subject ends up being unique.

One thing that seem to be consistent is in the body of the form that we wish to have an email routing rule configured, the Job Title is always blank, and appears as the following:

Job Title: 

Is there a way using the body specifying the above to create a routing rule?

 

Many Thanks

[HHH]

Not exactly sure what the email looks like but try using criteria "WHERE body LIKE '%Job Title:CHAR(10)%' OR body LIKE '% Job Title:CHAR(13)%'

That looks for the string Job Title: followed by a carriage return or a line feed.
If it's an Oracle database I think it's CHR(10) and CHR(13) instead of CHAR.

 

[Adam Toms]

Thanks @HHH I will certainly explore those options you've suggested above, and will report back on how I get on.

[Adam Toms]

I've explored those options that @HHH, kindly suggested, the form which is then sent via email originates as a HTML form. I'm wondering if I can use Job Title: <br> which highlight a break in HTML, but not sure how this will cope with the routing rule criteria.

[Victor]

6 minutes ago, Adam Toms said:

the form which is then sent via email originates as a HTML form

This is irrelevant for routing rules because they always use the Plain Text part of an email message when evaluating rule expressions. So using HTML tags (such as <br>) in expressions will not do anything as there are no HTML tags in the Plain Text part of the email...

However...

On 04/07/2024 at 14:19, Adam Toms said:

the Job Title is always blank, and appears as the following

You can use REGEX_MATCH function in the rule expression which allows you to identify the pattern more reliably than how a LIKE would...

https://docs.hornbill.com/esp-fundamentals/reference-guides/express-logic

[Victor]

On 04/07/2024 at 14:42, HHH said:

Not exactly sure what the email looks like but try using criteria "WHERE body LIKE '%Job Title:CHAR(10)%' OR body LIKE '% Job Title:CHAR(13)%'

This won't work either because "Job Title:CHAR(10)" is seen as a string, since it is enclosed in quotes so it won't be evaluated as the CHAR() function...

[Adam Toms]

Thanks @Victor for your advice on this does look like the REGEX_MATCH will help us come up with a more reliable way to achieve this.

Many Thanks
Adam