Skip to main content

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)

 

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

 


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


Reply