Solved: CONCATENATE() different column values with a dinam... - Page 2

Gianlucapozza · 09-01-2022 01:04 AM

Hello, Im trying to concatenate 6 values into a virutal column that works as a summarization column in a table view and I need those values separated by a separator of some kind. Ive used as separator " " since I wanted the space but, if the values of the columns concatenated are empty then the virtual column is not blank but made of " " (5 spaces). Is there a way to concatenate those values without having to force a separator?

Steve

Try this:

SUBSTITUTE(
  CONCATENATE(
    LIST(
      [Invio dati],
      [Pulizia canali],
      [Canali],
      [Batteria],
      [Minimo notturno],
      [Idrovalvola],
      [Note]
    )
    - LIST("     ", "")
  ),
  " , ",
  " "
)

View solution in original post

CONCATENATE() different column values with a dinamic separator