When cleaning data (for example cleaning scraped data), separating a property into several properties is a simple yet powerful feature.

Splitting text into properties is perfect to:

Step 1: Open the Split Property tool

Open the "Split Property" tool in the "Edit" menu.

The tool selects the items to process in this order:

  • If you have selected items in your collection, it will process them
  • If you have a filter or a full-text search term, it will process the filtered items
  • Otherwise, it will process all your collection items
Open the Split Property tool
Open the Split Property tool

And select the property you want to split. Only text-based properties are available. Checkbox, Datetime, etc. properties are not available.

Step 2: Split Property options

Delimiter

Split Property options
Split Property options

Then, select the delimiter to use. Common delimiters are available:

  • @ (at)
  • Comma
  • Semicolon
  • Dot
  • Tab
  • Space
  • @ (at)

Or you can write custom delimiter characters.

Notes
If you write a multi-characters delimiter, the whole "pattern" will be searched (and not each letter). If you need to split on multiple delimiters, run the Split Property tool once with a delimiter, and do it again for each delimiter.

Custom Delimiter
Custom Delimiter

Max Parts

The second option is "Max Parts". The "Split Property" process creates additional properties in your collection and keeps your source property unchanged.

With "Max parts", you decide how many new properties will be created to store the splitting parts. If you set a number too high, useless properties will be created.

Step 3: Preview and run

Like many cleaning and editing tools in Datablist, a preview step is shown before running the algorithm.

The preview screen shows the properties that will be created and a sample of the splitting algorithm on your first items.

Preview
Preview

If the results look good, click on "Split property" to run the algorithm on all your current items.

Examples

Split Full Names into First Name and Last Name

Some CRMs use Full Name, while others split it into First Name and Last Name. The result is a headache to consolidate your lead lists.

With Datablist Split Text tool, it's easy to convert your Full Name property into First Name and Last Name. Run the algorithm on your Full Name property and use a Space delimiter.

Split Full Name into First Name and Last Name
Split Full Name into First Name and Last Name

Split email addresses into name and domain

You can learn a lot on your leads with their email addresses. The email domain is a good example. Does it belong to a corporate website, an email provider, or a disposable email service? To clean your email list, getting the domain address is the first step.

Run the Split Text algorithm on your Email property with the @ delimiter.

Split email address to get the domain
Split email address to get the domain

Split multi values property into single-value properties

The Datablist tool to merge duplicate items merges conflicting data by combining texts into a single property.

Datablist Split Property algorithm is complementary to Datablist Duplicates Finder. To force a single value in a property (for email addresses, website URLs, etc.), run the algorithm with the same delimiter.

Split multi-values into several properties
Split multi-values into several properties