Contact Washing Machine actions

When configuring the Contact Washing Machine app on the campaign canvas and program canvas, you can select up to seven actions to perform on the source field. The following table outlines their purpose and provides examples.

Action

Description
Trim Removes all white space.
Trim Left Removes white space to the left of the text.
Trim Right Removes white space to the right of the text.
Lowercase Turns all letters to lowercase.
Uppercase Turns all letters to uppercase.
Propercase Capitalizes the first letter of each word.
Compose Builds up a string of text from static values and Eloqua contact fields and places it into the destination field. Press Ctrl + Space to view the list of available static and contact fields.

Example: Entering ${C_FirstName} ${C_LastName} retrieves the first name and last name of the contact and places it in the destination field (Email Display Name).
An image of the Contact Washing Machine Compose Configuration window.
RegEx Extract Extracts matching values from the source field and places them into the destination field using regular expression (RegEx). The extracted text is matched based on the first bracketed expression (known as the capturing group). Your expression must contain a capturing group.
Examples: If the source field contains a simple email address such as johnsmith@example.com), the following examples show how to extract different values.

Extract email address:

  • Expression: (\w+@\w+.com)
  • Extracted text: johnsmith@example.com

Extract user name: The following example has two capturing groups (one matching before the @ and one matching after). Only the first capturing group will extract matching values.

  • Expression: (\w+)@(\w+).com
  • Extracted text: johnsmith

Extract company name: The following example has two sets of bracketed expressions. Only the capturing group (without the ?) is extracted.

  • Expression: (?:\w+)@(\w+).com
  • Extracted text: example

Important: Regular expressions that include \w match for words, not for special characters such as the ., which is often included in user names. For example, you can extract the company name (example) from john.smith@example.com but the user name would be extracted as smith, which is incorrect.

Tip: You can test your RegEx by running a test against your existing data. Alternatively, you can validate your expressions using regex101.com.
RegEx Replace

Allows you to search and replace contact information using regular expression (RegEx).

Examples: To apply consistent formatting to phone numbers, you can use the following RegEx examples to find the string in the source field and replace it with a formatted string.
  • Source field: +1111234567891
  • Regular expression to find: ^(\+[\d]{1,3}|0)?(\d{3})(\d{3})(\d{4})$
  • Regular expression replace: ($1) $2 $3-$4
  • Destination field result: (+111) 123 456-7891

To format North American phone numbers:

  • Source field: 1234567891
  • Regular expression to find: ^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$
  • Regular expression replace: ($1) $2-$3
  • Destination field result: (123) 456-7891

Tip: You can test your RegEx by running a test against your existing data. Alternatively, you can validate your expressions using regex101.com.
Set to Blank Set to Blank clears data in the source field.
Math Math allows you to enter a mathematical expression to update your destination fields. Use simple operators and brackets to create your expressions: +, -, /, *, ^, (), []. Press Ctrl + Space to view the list of available source fields. The following expressions are supported:
  • abs(X): absolute value
  • acos(X): arc cosine
  • asin(X): arc sine
  • atan(X): arc tangent
  • cbrt(X): cubic root
  • ceil(X): nearest upper integer
  • cos(X): cosine
  • cosh(X): hyperbolic cosine
  • exp(X): Euler's number raised to the power (ex)
  • floor(X): nearest lower integer
  • log(X): natural logarithm (base e)
  • log10(X): logarithm (base 10)
  • log2(X): logarithm (base 2)
  • sin(X): sine
  • sinh(X): hyperbolic sine
  • sqrt(X): square root
  • tan(X): tangent
  • tanh(X): hyperbolic tangent
  • signum(X): signum function
  • rand(min, max): random number function
Examples:

abs(X): absolute value

  • Example: abs(-5000)
  • Result: 5000
You can also use a contact field for this expressions, such as abs(C_Company_Size).

floor(X): nearest lower integer

  • Example: floor(5.9)
  • Result: 5

rand(min, max): random number function

  • Example: rand(1,10)
  • Result: Generates number between 1 and 10 inclusive

Simple expression: ${C_Annual_Revenue}/1000000

Nested brackets: (${C_NumericField1}*${C_NumericField2}*[${C_NumericField3}+${C_NumericField4}])+${C_NumericField5}
Replace Replace searches for a string of text in your source field and replaces it with the desired text in your destination field. Your search can be case sensitive. The text in the find field cannot be blank.

An image of the Contact Washing Machine Replace Configuration window.
Lookup Lookup let's you standardize and add to your contact information by pulling data from lookup tables. This helps minimize fields for customers to fill out on forms. The following lookup tables are currently available:
  • Celebrity match: Determine if a fake celebrity name has been entered for a contact (returns TRUE if it matches a celebrity name and otherwise returns blank)
  • First name to gender: Lookup a gender (Male, Female, or Unisex) based on a first name (for example, First Name: ken becomes Gender: Male; First Name: sam becomes Gender: Unisex)
  • Title to level: Lookup a level based on a title (for example, Title: vp finance becomes Level: Vice President)
  • Title to role: Lookup a role based on a title (for example, Title: vp finance becomes Role: Finance)
Site-specific custom lookup tables may also be available.

Learn more

Contact Washing Machine app

Oracle Eloqua AppCloud apps