Create concatenate field based on condition (if a certain field is filled or not)

Question

I have a table created like the one on the picture and would like to create a concatenate field with the name of the columns that have stars associated with. Is it possible?

For the first record the formula should return (M&A, IPO, Turn Around, Financiamento/Captação), for the third record the formula should return (IPO, Planejamento Estratégico)

Stephen_Orr1 · Accepted Answer

Hi @tsallis, Give this a try REGEX_REPLACE(    IF({M&A}, 'M&A, ','') &    IF({IPO}, 'IPO, ','') &    IF({Turn Around}, 'Turn Around, ','') &    IF({Planejamento Estratégico}, 'Planejamento Estratégico, ','') &    IF({Financiamento / Captação}, 'Financiamento/Captação, ','')    ,    '[, ]*$',    '') -Stephen

tsallis · Answer

Hi @tsallis, Give this a try REGEX_REPLACE(    IF({M&A}, 'M&A, ','') &    IF({IPO}, 'IPO, ','') &    IF({Turn Around}, 'Turn Around, ','') &    IF({Planejamento Estratégico}, 'Planejamento Estratégico, ','') &    IF({Financiamento / Captação}, 'Financiamento/Captação, ','')    ,    '[, ]*$',    '') -Stephen I really have to learn more about REGEX it is really usefull. Thanks for the tip Stephen

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded