Help me get rid of his commas please 😅

[Julien_BOIDROU]

Hello everyone, I have a problem that I can’t solve.

When I generate my newsletter with a formula that uses the ForEach() and Concatenate() functions,

I have commas that appear between my “blocks”

Do you have an idea to avoid this not very aesthetic problem?

Thanks in advance.

The formula in question:

[Prochaine Veille].Categorie.Unique()
  .Sort(
    true, [DB Categorie].[Ordre NL]
  )
  .FormulaMap(
    CurrentValue
      .WithName(
        Rubrique,
        Concatenate(
          Upper(CurrentValue.Titre),
          LineBreak(),
          [Prochaine Veille].Filter(Categorie = Rubrique)
            .Sort(
              true, Outils
            )
            .FormulaMap(
              Concatenate("■ ",[Veille Newsletter],
                LineBreak()
              )
            ),
          LineBreak()
        )
      )
  )

[Scott_Collier-Weir]

Those commas indicate a list of items, you can join together lists though with defined characters using the join function. Can you try changing on a join(lineBreak()) To the end of everything and see if that works?

If not feel free to share the dock and I’ll take a look!

[Julien_BOIDROU]

That’s exactly right Scott!!!
Thank you very much i just put .join(lineBreak()) at the end of the formula, and it works great