Help

Formula to get the last element of a list of elements separated by coma

724 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Comercial_Tesal
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone. Just want to share a formula to get the last element of a list of elements separated by coma. This formula also eliminates the empty spaces before and after the resulting text if there were any. I am sure it will be helpful to someone in the future.

TRIM( REGEX_EXTRACT( {your_field} & ",", "([^,]+)," ) )


Regards.

0 Replies 0