In a formula column, the EXTRACT_ELEMENT() function allows you to extract an element contained in a cell according to various parameters: 

- You can extract the 1st element

- You can extract the last element

- You can choose the element separator 

For example, you want to know which was the last action taken for your customer among a list of actions

Formula

1st element

EXTRACT_ELEMENT(Colonne avec multiples éléments,1,;)

The first parameter is the column containing your multiple elements.

The "1" conditions the search for the 1st element.

The ";" is our separator here. TimeTonic uses "," as the default separator. The formula works by default with this type of separator. No need to notify it. 

Last element

EXTRACT_ELEMENT(Colonne avec multiples éléments,-1)

The first parameter is the column containing your multiple elements.

The "-1" conditions the search for the last element.

The ";" is our separator here. TimeTonic uses "," as the default separator. So the formula works by default with this type of separator. No need to notify it. 

Example

1st element

EXTRACT_ELEMENT(Colonne actions commerciales,-1)

I want to know what stage we are at by extracting the last item from a list of stages.

And here is the result, the column "Commercial stage" returns the last stage:

Last element with separator

EXTRACT_ELEMENT(Colonne actions commerciales,1,;)

I want to know what stage we are at by extracting the first item from a list of actions.

And here is the rendering, the column gives you the first action taken: