Skip to main content
Hi, 

 

So I needed to create a large text field that collated a large text field from all of its child objects. 

 

Now I have managed this by using a flow that loops through all of the child objects every time one is edited and basically collates the field in a text collection variable. This then populates in a text template using the collection variable. 

 

Now my issue is that the variable automatically adds a comma between items and a '[' at either end. Is there a way for these to be removed? 

 

Thanks!

 

Shay
3 answers
  1. Jan 3, 2024, 8:10 PM

    Hey @Shay Rickles-McGreal

     

    The alternative to remove the commos from the text template.

    • Create a formula field type as text.
    • User formula 
      • SUBSTITUTE(<text template>, ',' , '')

    Or if you have any specific pattern that you wanted to remove can use the Old text and New text.

     

    SUBSTITUTE(<text template>, Old_value , New Value)

     

    Thank you