Using this function, the data before the specified substring will be returned. The result is returned as a text.
Examples:
We have a field called "Company Name" with the value 'Rapidi A/S'##BEFORE("Company Name", ' ')
The formula will return 'Rapidi'.##BEFORE("Company Name", 'Rapidi')
The formula will return NULL because there is no value before 'Rapidi'.##BEFORE("Company Name", 'A/S')
The formula will return 'Rapidi' with a blank at the end. ##DBLOOKUP('DESTDS','Account','Customer_No__c',BEFORE("DimensionDisplayValue",'-'),'Id'))
The nested formula will retrieve the value that is stored before the first minus sign - in the field 'DimensionDisplayValue'. If the vale retrieved equals Customer_No__c, then the ID will be retrieved.