Extract List Items (2023)

Extract List Items (2023)

Master Tag
Tips & Tricks
Created
Jan 6, 2023 03:31 AM
How It Works
Usage
Web Tags
Formula
Alternatives
Cover
Extract list items in a string separated by commas
Extract list items in a string separated by commas
notion image
 

First Item

replace(prop("Name"), "[,].*", "")

Items Between First and Last

Change the number inside the curly brackets {…} to specify item. For example, 1 will extract the 2nd item, 2 will extract the 3rd item, etc.
replaceAll(replace(prop("Name"), "(?:[^,]*, ){1}", ""), ",.*", "")

Last Item

replace(prop("Name"), ".*[,] ", "")
 
Atlas
Atlas