Help

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

734 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Comercial_Tesal
6 - Interface Innovator
6 - Interface Innovator

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