Split text to multiple columns via comma delimiter

[Cody_Anderson]

Hi! First time poster here.

I have a ‘record creation’ trigger via Zapier that takes certain emails from gmail and enters key information into an Airtable. as a part of the migration I am collecting the names and emails of those cc’d on the email. there can be upwards of 8 or so individuals in the cc field which means i’ll need a unique column (or row) created for each email (will plan to do the same for the contact’s name as well).

Haven’t been able to figure out the formula to make this possible but really just need something to create a new value for each comma separated value included in the cell.

Thanks in advance for the help here!

[Justin_Barrett]

Welcome to the community, @Cody_Anderson! :grinning_face_with_big_eyes: I wrote an answer to a similar question recently. The formula can be pretty easily adapted to your situation.

Splitting text to alternate columns separated by ; Formulas

Welcome to the community, @Jack_Richardson! :smiley: This can be done using four similar regular expression functions. Here’s the formula for {Name 1}: IF( {One Line Separated by ;}, TRIM( REGEX_REPLACE( {One Line Separated by ;}, "(.*)(?:;)(.*)(?:;)(.*)(?:;)(.*)", "$1" ) ) ) [Screen Shot 2021-04-07 at 5.52.00 AM] This works by capturing in groups—the parts wrapped in parentheses—but only matching and not capturing the semicolons. The REGEX_REPLACE() function …