Value Transforms: Regex Find and Replace Follow

Introduction

As part of our Value Transforms functionality, we offer the ability to perform Regex Find and Replace.

Regex is short for Regular Expression, and we use it to search for formats, rather than actual values. This means you can search for a certain format, and replace it with something else. This is useful, for example, if you want to reformat date or telephone number values.

The Convertr platform supports PCRE Regex values. As this can be a tricky language to master, this document will also cover some commonly used examples.

Related documentation:

• Value Transforms
• Advanced Value Transforms/Manipulation: Trimming
• Advanced Value Transforms/Manipulation: Find and Replace
• Advanced Value Transforms/Manipulation: Regex Find and Replace
• Advanced Value Transforms/Manipulation: Concatenation
• Advanced Value Transforms/Manipulation: Casing
• Advanced Value Transforms/Manipulation: Hashing
• Advanced Value Transforms/Manipulation: Ordering

Best practice:

This document explains how to setup Value Tranforms at an Campaign level, however this method does not allow importing/copying of configurations across campaigns.

There is an option to setup Value Transforms at a Advertiser Level, where any configurations can then be imported into a campaign which removes repeated manual setup for any subsequent campaigns. Therefore, setting up Value Transforms at an Advertiser level is recommended. 

Setup Process

1. Within a campaign, click the Admin menu and select Value Transforms.

2. Enable Value Transforms by using the toggle.

3. On this page, select Add.

4. Here, you'll need to fill out each field:

• Label: A name for the Value Transform
• Original Fieldname: the field you are looking to reformat
• New Fieldname: the field we will store your reformatted value in
• Order: This will dictate when this Value Transform should run, in relation to any other transformations set up in the campaign. By default this is 0, meaning that it will run first. Increasing the order changes when it will run.

5. You will need to select Manipulate. This will give you a type dropdown, where you can select Regex Find and Replace.

6. Enter your find and replace Regex, and click Add.

Your setup is complete from here! You'll be able to use the Preview at the bottom to check that it reformats as intended:

Common Regex Examples