Oracle Eloqua: Wildcard Patterns

Reenu Vasnani

Fuzzy on exactly what wildcard patterns can do for you? Take this 5-minute OnDemand Course, and learn how to use wildcard patterns to:

• Search Contacts more efficiently
• Separate approximate percentages of Contacts

We welcome your thoughts and comments.

Learn More from Oracle University

This Course is included with the Oracle CX Marketing Learning Subscriptions from Oracle University. Subscribers can view this Course anytime within their subscription. If you're not yet a subscriber, take a few moments to learn more about available Oracle CX Marketing Learning Subscriptions and other Oracle University training options. If you have questions, talk to your account manager, email the education team, or submit a service request.

Michael Kirsner-Oracle

This was great, by the way! Glad to have a video demo to share with folks in my Fundamentals of Segmentation class!

Clementina Altamirano-Oracle

This was great, by the way! Glad to have a video demo to share with folks in my Fundamentals of Segmentation class!

Hi! So glad this will help as a resource for the class

Brad Williams

As a quick reference this has really helped me when I am trying to remember what wild card characters do. I hope you find this helpful.

Character	Description	Example
*	Matches any number of characters. You can use the asterisk (*) anywhere in a character string.	wh* finds what, white, and why, but not awhile or watch.
?	Matches a single alphabet in a specific position.	b?ll finds ball, bell, and bill.
[ ]	Matches characters within the brackets.	b[ae]ll finds ball and bell, but not bill.
!	Excludes characters inside the brackets.	b[!ae]ll finds bill and bull, but not ball or bell. Like “[!a]*” finds all items that do not begin with the letter a.
-	Matches a range of characters. Remember to specify the characters in ascending order (A to Z, not Z to A).	b[a-c]d finds bad, bbd, and bcd.
#	Matches any single numeric character.	1#3 finds 103, 113, and 123.

andrepazleal

Can multiple cases be used like multiple email adress domain, @example.com,@example2.com?

Calin A.

Can multiple cases be used like multiple email adress domain, @example.com,@example2.com?

Hi @andrepazleal,

If you're looking for specific patterns in contact search or segmentation you can use

*@yahoo.com in one query

OR

*@gmail.com as a second query

OR

...

With a max of 15 separate queries in one filter criteria for segments. You can't add multiple comma separated patterns, from my knowledge.

However you can leverage quicklists or picklists if you want to pinpoint more domains.

Quicklists should be flattened in shared lists as they keep on getting generated and can add up.

Picklists preferably as you can reuse, add, edit easily.

Hope this helps.

Calin A.

Farrell

How can I search for special characters like .?*
e.g. I want to find email address that's like [email protected], [email protected], etc..
i tried with wildcard "*.com[!.]*" but no success.. it'll work if I use "*.com?" but this is only 1 characters after ".com"

Thank you.