Hello!

Try this

REGEX_EXTRACT(text,"([^,]+,?){2}")

You can change the location by changing the number in the {2} part.

REGEX_EXTRACT(text,"([^,]+,?){2}")

Hello, BUTthis is not working

thank you for your comeback https://airtable.com/shroD4pRoA52pXcg6
Franck

REGEX_EXTRACT(text,"([^,]+,?){2}")

Hello, Thank you for your return unfortunately it does not work

thank you for your feedback https://airtable.com/shroD4pRoA52pXcg6 FRanck

Hello, Thank you for your return unfortunately it does not work

thank you for your feedback https://airtable.com/shroD4pRoA52pXcg6 FRanck

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.

best regards

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

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

It was better this way
Change + to *

Your pursuit of data extraction seems like a valuable endeavor. Extracting specific information from the "noms des participants" rollup field based on different fields like "Nom Prenom 1," "...2," "...3," and so on can be quite a task, but it's great that you're determined to tackle it.

Speaking of data extraction, it's interesting to note that platforms like Nannostomus provide accessible solutions for customers looking to simplify the process. Easy and accessible data extraction tools can save a lot of time and effort, making tasks like yours more efficient.

It's intriguing to think about the possibilities that such tools could bring to your data exploration project.