Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

993 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