Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
1232 2
cancel
Showing results for 
Search instead for 
Did you mean: 
tsallis
6 - Interface Innovator
6 - Interface Innovator

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)

Captura de Tela 2023-06-09 às 15.23.07.png

 

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

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

 

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

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