Help Needed: Formatting Messages with Bullet Points for Sequencer | Clay

Help Needed: Formatting Messages with Bullet Points for Sequencer

seeing if anyone can help as clay are out of hours, i'm currently trying to format a message to be pushed to a sequencer, it has bullet points, the formula i used was {{Message 3 Body}}?.replace(/ /g, " ")?.replace(/\n/g, "<br>") - this works but was generated when i didn't have bullet points the format i need all my messages to follow is this one </li></ul>HelloFresh Used Chattermill to: <ul> <li>Increase Average Order Values (AOV) by 30%</li> <li>Grow average orders per customer by 4%</li> <li>Launch 7 new brands based on customer insights</li> </ul> They used customer insights to guide strategic growth - spotting trends, testing new ideas, and expanding their offering in line with what customers really wanted.</li></ul> i've got 26,000 messages generated, how do I recreate the prompt so that it adds bullet points to all the messages

21 comments

Channeled
APP
·
·
To add bullet points to your 26,000 messages in the specified format, you'll need to modify your existing formula. Here's a suggestion for the new formula: LBKS{{Message 3 Body}}?.replace(/ /g, " ")?.replace(/\n/g, "br")?.replace(/• /g, "li")?.replace(/^(.*?)$/gm, "li$1/li")?.replace(/^/gm, "ul")?.replace(/$/gm, "/ul")LBKSThis formula should convert your bullet points into the desired HTML-like format. It replaces bullet points with "li" tags, wraps each line in "li" tags, and surrounds the entire content with "ul" tags. Could you please share a sample of one of your messages in its current format? This will help ensure the formula works correctly for your specific case.
Sources: Claybooks: Create personalized handwritten letters in bulk | Clay.com Claybooks: Automate multi-step sequence messaging with Twain | Clay.com
Josephine V.
·
·
HelloFresh Used Chattermill to: Increase Average Order Values (AOV) by 30% Grow average orders per customer by 4% Launch 7 new brands based on customer insights They used customer insights to guide strategic growth - spotting trends, testing new ideas, and expanding their offering in line with what customers really wanted.
Josephine V.
·
·
that formula made it add bullet points all over the email not just in the central point
Channeled
APP
·
·
To modify your formula and add bullet points in the specified HTML-like format for all 26,000 messages, you can use the following formula: {{Message 3 Body}}?.replace(/ /g, " ")?.replace(/\n/g, "br")?.replace(/^(.+)/, "/ul") This formula will: 1. Replace spaces with non-breaking spaces 2. Replace line breaks with "br" 3. Wrap each line with "li" and "ul" tags 4. Add opening "ul" at the start and closing "/ul" at the end After applying this formula, review the output to ensure it meets your requirements.
Sources: Formulas FAQ: How can I format my text with line breaks and paragraphs before sending it to my email sequencer?
Summiya B.
·
·
Write a short case study message in HTML format using this structure: First line: "{Brand} used {Product/Service} to:" Then give 3 short bullet points (in <li> format) describing what they achieved Then a closing sentence summarizing how they used insights or strategies to drive results. </li></ul>{Brand} Used {Product} to: <ul> <li>{Point 1}</li> <li>{Point 2}</li> <li>{Point 3}</li> </ul> {Closing sentence}</li></ul>
Josephine V.
·
·
is there a formula i can use that will change all my messages into that formula
Summiya B.
·
·
"</li></ul>" + Brand + " Used " + Product + " to:<ul>" + Message.replace(/\n+/g, "</li><li>").replace(/^/, "<li>").replace(/$/, "</li>") + "</ul>" + Summary + "</li></ul>"
Summiya B.
·
·
Try this may be this helps U.
Josephine V.
·
·
okay i will try
Josephine V.
·
·
thank you
Josephine V.
·
·
Summiya B. so close, that generated it to look like this Hi Hannah, Following on from my last note, I wanted to show you what is possible when you unify and analyse your customer feedback at scale.
HelloFresh Used Chattermill to:
Increase Average Order Values (AOV) by 30%
Grow average orders per customer by 4%
Launch 7 new brands based on customer insights
They used customer insights to guide strategic growth - spotting trends, testing new ideas, and expanding their offering in line with what customers really wanted.
If you're curious, I'd be happy to send over a full case study or share a quick overview. Best, I don't want to bullets on the two in bold, do you know how i'd also the formula to reflect that {{signature}}
Summiya B.
·
·
Try this Brand + " Used " + Product + " to:<ul><li>" + Message.replace(/\n+/g, "</li><li>") + "</li></ul>" + Summary
Josephine V.
·
·
it did not like that at all
Josephine V.
·
·
Summiya B.
·
·
What is the error
Josephine V.
·
·
it just says error evaluating formula
Josephine V.
·
·
i can't see anything else
Summiya B.
·
·
Brand + " used " + Product + " to:<ul><li>" + Message.replace(/\n/g, "</li><li>") + "</li></ul>" + Summary
Josephine V.
·
·
Bo (.
·
·
Hey Josephine - Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Channeled
APP
·
·