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

[tsallis]

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 solution]

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]

I really have to learn more about REGEX it is really usefull. Thanks for the tip Stephen