Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

formula for to extract text from the rollup field

Topic Labels: Formulas
1299 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Franck_GENTILI1
6 - Interface Innovator
6 - Interface Innovator

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

4 Replies 4
Elyes80
6 - Interface Innovator
6 - Interface Innovator

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.

 

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

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

 

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