formula for to extract text from the rollup field

[Franck_GENTILI1]

hello community What would be the formula for to extract from the rollup field "participant name (from imported table)" the names entered in this field and to report them individually in the formula fields, do you have an idea of the formula to use thank you Franck 

https://airtable.com/shroD4pRoA52pXcg6

[Elyes80]

Bonjour Franck,

You have a few options to accomplish this. I think you can either use the REGEX_REPLACE() function (you can check this post  ), or by using a simple formula with a combination of Left/Mid, Search and LEN functions (check this post and video ).

Hope it helps.

[Franck_GENTILI1]

hello and thank you for your answer, my skills are limited with regard to such complex formulas, I tried several options but the result returns an error! Best regards

hello and thank you for your answer, my skills are limited with regard to such complex formulas, I tried several options but the result returns an error! Best regards

https://airtable.com/shroD4pRoA52pXcg6

0 Kudos

Reply

[Franck_GENTILI1]

I found the solution by adding "ARRAYJOIN" in the formula.
Modify location 1 ([^,]+,?){1}") to extract the rest of the string in the following fields.

The formula

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

best regards

[Franck_GENTILI1]

Hello
But here is the problem I encounter on fields that do not contain data

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