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


Terms & Conditions