Split Columns - Less Documentation

Configuration
Example: I want to do something fun 🍌
Example: Getting the country from an address
Example: Splitting line items to rows

The Split Columns tool enables you to break apart a piece of text using a “marker” (delimiter) - like how you might cut a piece of paper where you see dotted lines. The Split Columns tool can be highly customized. You can choose your delimiter, if you want to split to rows or columns, how many columns/splits you want and whether you want to split from left-to-right or right-to-left.

The Split Columns tool is very similar to the Text to Columns function in Excel

Configuration

The Split Columns tool consists of three required input and two optional input.

Split column

Select the column you want to split.

Delimiter

Input the delimiter by which you want to split.

The delimiter is case-sensitive.

Split type

Select if you want to split to rows or columns.

Max splits (optional)

This is an optional input. Select how many split you maximum want to create. This can be helpful if you data structure is not consistent and you want a particularly part of the content split.

Direction (optional)

This is an optional input. Select the direction to want to split - you can choose left-to-right or right-to-left.Defaults to left-to-right.

Example: I want to do something fun 🍌

Here you can see how you can split a column by a text delimiter into unlimited columns.

Example: Getting the country from an address

Here we have a number of addresses that differ in the format and country. We’re interested in the country. If we split without a direction or max split, we would get the following result:

We see that we sometimes have country in the fourth column and sometimes in the fifth because of the differing format. If we add a direction of right-to-left and set a max split of 1, we get the following result: