I have mutliple comments per record ID like this:
and I would like to merge them into a single value with line breaks like this:
How would I do this?
Thank you.
Interesting use case.
I was able to do this with the Summarize tool...
Group by the ID, and Concatenate the Comment using "\n" (New Line) as the Separator.
It shows up in a Browse after that as being in two lines, but not sure about then when you output it. I've tried outputting to Excel (which is what it looks like you are wanting) and Excel doesn't seem to recognize the embedded new line.
Maybe someone else can add to this?
Jimmy,
You would use a summarize tool and then a formula. The summarize is a concatenation function and the formula is a regular expression. I've included a working module for you to examine.
Thanks,
Mark
Mark,
Most don't realize you can insert many different separators in the Summarize Concatenate parameters, so that would eliminate your Formula tool.
However, I'm still not getting it to output to Excel where it recognizes the new line.
Any ideas on how we might get that to work?
Rod
Mark/Rod,
Thanks for your replies. I need to be careful of the separator as these comments contain all sorts of characters, some even contain line breaks. So I'll need to test these. Thank you! -Jimmy
to wrap up, I am going to use <br> as my separator as this will be going into an html field within Salesforce. Thank you both for your help!
Dear Maequee,
Thanks for the explanation.
When I tried to use your solution, I found out that the '/n' seperator does not work. As you may see from the below ss, in the concat_email column I see /n in text format. However, I want all different e-mails in the new lines.
Could you please help me on this?
When I tried to use your solution, I found out that the '/n' separator does not work. As you may see from the below ss, in the concat_email column I see /n in text format. However, I want all different e-mails in the new lines.
