BEFORE

BEFORE(data,substring);

Using this function, the data before the specified substring will be returned. The result is returned as a text.

 

Example:

We have a field called "Company Name" with the value 'Rapidi A/S'

##BEFORE("Company Name", ' ');

Returns 'Rapidi'.

 

##BEFORE("Company Name", 'Rapidi');

Returns '0' (null) since no data exists before 'Rapidi'.

 

##BEFORE("Company Name", 'A/S');

Returns 'Rapidi ' (with a blank at the end).