Formulas - How to split a text string?

The EXPLODE TEXT formula can be used to explode or split a text string using a delimiter or separator character.

• Field: You should select the field that has the text string you want to explode
• Separator: You should type the character that would be used as a reference to split the text string
  For example, to split a text string with Blank Spaces, you should use the char ^ as shown in the sample inside the function setup below
• Index: Once the text string has been split, it is possible to define the index of the element to keep between the obtained elements

1. Go into the Fields Mapping step of the Bridge
2. Switch the bridge to editing mode on the top right
3. Click on the three dots near the field that you need to assign the function and select Add formula
4. Select the TEXT >> EXPLODE TEXT function
5. On the Field drop-down, select the Source field related to the name, in our example, it would be the Full nam**e. This source would give us a string like the following: John Doe Marketing Department
6. In the Separator field, type the delimiter character for the explosion, and in our sample, it is “^” since the string is delimited by blank spaces
7. Then, we will need to set the Index value to 2, since we only want to get the Lead’s last name. This will give us the following: Doe. If we would like to get the lead’s first name, we will have to set the value to 1. Or, if we would like to get the lead’s department after its last name, we should set the explosion limit to 3. This would give us the following output: Doe Marketing Department
8. Once done, click on Confirm and Save & Publish to save the changes

Related Articles

• Formulas - How to split the Full Name into First and Last Name?
• Getting Started with LeadsBridge Formulas
• Formulas - How to remove undesired chars?
• Comprehensive Fields Mapping Guide
• Step-by-step guide on how to create a Bridge

• Explode_text.jpg90 KB