Phone Number Validation using Contact Washing Machine
in Eloqua
Use case: Let us say you wanted to have phone numbers to be in the following format without spaces and “00” or “+” in the starting of the phone number.
- Open your Program Canvas or Campaign Canvas and drag and drop CWM app, click on configuration.
- Assuming you are aware of CWM app, select Action as “RegEx Replace” and enter below code.
Find: \D ->it will remove all the spaces, “-“from the phone number.
Replace: Blank
3. Now, select Action as “RegEx Replace” again and enter below code:
Find: ^\s*(?:\+?(\d{1,3}))?[-. (]*(\d{3})[-. )]*(\d{3})[-. ]*(\d{4})(?: *x(\d+))?\s*$
Replace: 00$1$2$3$4 or +$1$2$3$4
Tagged:
0