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.
Formula to get the last element of a list of elements separated by coma
+5
Be the first to reply!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.