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
formula for to extract text from the rollup field
+4
+6+4Bonjour 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.
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 regardshello 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
0 Kudos
+4hello 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 regardshello 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
0 Kudos
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
+4I 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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.