Introduction
This section focuses on the Trim function, which allows you to automatically trim data.
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 set up Value Tranforms at a Campaign level, however this method does not allow for importing/copying of configurations across campaigns.
You can set up Value Transforms at an Advertiser Level, where configurations can then be imported into a campaign, removing repeated manual setup. Our recommendation is to always set up them up at the Advertiser level.
Setup Process
1. Within a campaign, navigate to Admin>Value Transforms.
2. Enable Value Transforms by using the toggle.
3. Click Add, and populate the modal that opens.
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 from the three Trim features..
6.a. Trim
The Trim functionality will remove any spaces from any value submitted under the given field. Select Trim from the Type dropdown menu. This function will remove any excess spaces inputted on the start or the end of any value.
i. To add Trim to your transformation, select the Type Trim and click Add.
As shown in the Preview input, spaces are trimmed from the value.
6.b. Trim Start
The Trim Start functionality will remove a stated value from the given form field.
i. To add Trim Start to your transformation, select the Type Trim Start.
ii. Enter the value you would like to trim from every value in the Value box 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:
6.c. Trim End
The Trim End functionality will remove a stated value from the given form field.
i. To add Trim End to your transformation, select the Type Trim End.
ii. Enter the value you would like to trim from every value in the Value box 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:
7. Click Save.