Help

extract text from lookup field with regex extract

Topic Labels: Formulas
490 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Franck_GENTILI1
4 - Data Explorer
4 - Data Explorer

Hello community

i am using a regex extract formula

to fill formula fields from a lookup field. the formula works well. But I have 5 formula fields and when the character string separated by commas only has 3 elements, the other two fields refer to the last letter of the last word.

REGEX_EXTRACT(ARRAYJOIN({Participant name (from Imported table)}),"([^,]+,?){1}")

Ex
Lookup contains
ALLIE Pierre, BELUFFI Maeva, MUD Adrien

Formula 1 field 1 =ALLIE Pierre
Formula field 2 = BELUFFI Maeva
Formula field 3 = MUD Adrian
Formula field 4 = n
Formula field 5 = n

https://airtable.com/shroD4pRoA52pXcg6

Thank you for your feedback
Best regards
Frank

0 Replies 0