BEFORELAST

BeforeLast(data,substring)

Returns all data before the last occurence of .

 

Example:

BeforeLast('Here we are', ' ')  will return 'Here we'

 

This formula can be used to split a name into firstname and lastname - use this function to get the firstname.

Example:

Name: Samuel Worobel

##BeforeLast("Name",' ') will return Samuel

 

Then, use the function Last() to get the lastname.