- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 09, 2023 01:05 PM
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)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 09, 2023 02:23 PM - edited Jun 09, 2023 02:24 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 09, 2023 02:23 PM - edited Jun 09, 2023 02:24 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 12, 2023 03:56 AM
I really have to learn more about REGEX it is really usefull. Thanks for the tip Stephen
