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