The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

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

posted May 12, 2023 3:18:51 PM

5 858 0

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