Split By Removes the value used for split?

If I have a text that is not a list and I want to use the split by function to separate the value into a list of texts, I can add :split by <h2

My assumption would be that the split by operator would simply look at the text and find all examples of <h2 present in the text and separate the text into a list of texts at the points where the <h2 value is present. I would not expect that the <h2 value would be removed and replaced with a comma, however that is what I am experiencing.

Would this be considered a bug or expected behavior?

If it is expected behavior, is there a way to take a text and separate it into a list of texts without replacing the <h2 with a comma, and instead leave the <h2 in tact?

My ultimate goal is to take the HTML below and separate it into a list of text by the different HTML tags.

<h1 id="unleashingthepowerofnocodetoolsforyourbusiness">Unleashing the Power of No-Code Tools for Your Business</h1>
<p><img src="https://pixabay.com/get/gc6a2e72153447fcc91c6d22773bbd4e452f287cc2afc1fc45227a97b1941d3b9b0142ebae01909c9ec9eee8172e76a26_1280.jpg" style="display: inline-block; max-width: 100% !important;"/><p>&#8205;</p>Photo by <a href='https://pixabay.com/users/Simon-3/'>Simon</a> on <a href='https://pixabay.com/photos/angkor-wat-cambodia-grown-together-435/'>Pixabay</a><p>&#8205;</p></br>Today, we live in a digital era where the technology landscape is constantly evolving. One phenomenon that has been making waves in the tech industry is the advent of no-code tools. These powerful platforms have democratized the process of building digital products, making it accessible to individuals who lack traditional programming skills. </p>
<p>No-code tools are transforming how businesses operate, offering streamlined solutions for everything from website creation and app development, to workflow automation and project management. If you're looking to harness the power of no-code tools to propel your business to new heights, this comprehensive guide is for you!</p>
<h2 id="nocodethegamechangerindigitalinnovation">No-Code: The Game-Changer in Digital Innovation</h2>
<p>No-code tools are innovative platforms that enable individuals to create functional digital products such as websites, mobile applications, and software without the need to write a single line of code. These tools employ an intuitive visual interface, allowing users to design and customize their products through simple drag-and-drop actions. </p>
<p>The beauty of no-code tools lies in their simplicity and accessibility. They have opened up the world of digital creation to a broader audience, empowering anyone with an idea to bring it to life. Whether you're a small business owner, a startup founder, or a freelancer, no-code tools provide you with the resources to build, launch, and scale your digital solutions without the need for extensive coding skills or a hefty budget.</p>
<h2 id="thetopnocodetoolstorevolutionizeyourbusinessoperations">The Top No-Code Tools to Revolutionize Your Business Operations</h2>
<p>Let's delve into the world of no-code platforms and explore some of the best tools that can help your business thrive in this digital age.</p>
<h3 id="1webflowthegatewaytobeautifulprofessionalwebsites">1. Webflow: The Gateway to Beautiful, Professional Websites</h3>
<p>Webflow is a robust no-code platform that empowers you to build stunning, professional websites without any coding knowledge. With its user-friendly drag-and-drop interface, Webflow provides an array of customizable templates that can be tailored to suit your business needs. It's a must-have tool for anyone looking to create responsive, visually appealing websites that stand out in today's crowded digital landscape.</p>
<h3 id="2bubbleyourtrustedcompanionforappdevelopment">2. Bubble: Your Trusted Companion for App Development</h3>
<p>When it comes to building sophisticated applications, Bubble is the no-code tool of choice. This platform enables you to design and launch fully functional apps, dashboards, and CRMs without needing to learn complex programming languages. Bubble's user-friendly visual interface allows you to assemble the components of your app, making it an invaluable asset for aspiring app developers and creative entrepreneurs.</p>
<h3 id="3mailchimpyourallinonemarketingplatform">3. Mailchimp: Your All-in-One Marketing Platform</h3>
<p>Mailchimp is a powerful no-code platform that simplifies the process of growing and understanding your audience. With its robust set of tools, Mailchimp allows you to conduct surveys, launch social media campaigns, categorize your customer databases, and much more. This platform is a great way to streamline your marketing efforts and build strong relationships with your customers.</p>
<h3 id="4parabolasimplifyingdatamanagementandautomation">4. Parabola: Simplifying Data Management and Automation</h3>
<p>Parabola is a no-code tool that makes data management and automation a breeze. This platform enables you to connect your data sources and automate your workflows with ease, making it an indispensable asset for businesses that handle a large volume of data.</p>
<h3 id="5voiceflowcraftingvoiceassistedappsmadeeasy">5. Voiceflow: Crafting Voice-Assisted Apps Made Easy</h3>
<p>Voiceflow is a standout no-code platform that empowers users to build voice-activated applications without any coding expertise. This tool offers a user-friendly interface that simplifies the process of creating voice apps for Google, Alexa, and other platforms.</p>
<h3 id="6bravotransformingdesignsintonativeapps">6. Bravo: Transforming Designs into Native Apps</h3>
<p>Bravo is a popular no-code tool that allows you to convert your Figma or Adobe XD designs into native apps for iOS and Android. If you have a knack for design and want to see your creations come to life as functional apps, Bravo is the tool for you.</p>
<h3 id="7makerpadyouronestopshopfornocodelearning">7. Makerpad: Your One-Stop Shop for No-Code Learning</h3>
<p>For those who are new to the no-code scene and want to learn more, Makerpad is an excellent resource. This platform offers a wealth of tutorials, tools, case studies, and other resources that can help you navigate the world of no-code and find the right solutions for your projects.</p>
<h3 id="8airtablestreamliningprojectmanagement">8. Airtable: Streamlining Project Management</h3>
<p>Airtable is a no-code tool that combines the functionalities of a spreadsheet with a database. This platform simplifies project management, allowing you to track projects, assign tasks, and monitor budgets with ease.</p>
<h3 id="9zapierautomatingworkflowsforefficiency">9. Zapier: Automating Workflows for Efficiency</h3>
<p>Zapier is a no-code platform that automates repetitive tasks, helping you to save time and focus on what really matters. This tool integrates with various web apps to automate workflows and streamline your business operations.</p>
<h3 id="10shopifybuildingyourecommercestore">10. Shopify: Building Your E-Commerce Store</h3>
<p>Shopify is a no-code tool that helps you to quickly set up your online store. With its range of integrations and easy-to-use interface, Shopify is a must-have for businesses looking to make their mark in the e-commerce space.</p>
<h2 id="thefutureofbusinesswithnocodetools">The Future of Business With No-Code Tools</h2>
<p>No-code tools are not just a passing trend; they're here to stay. By eliminating the barriers to digital creation, these platforms are enabling businesses of all sizes to innovate, grow, and compete in an increasingly digital world. </p>
<p>Whether you're looking to develop a professional website, design an engaging mobile app, automate your workflows, or enhance your marketing efforts, no-code tools offer a wealth of possibilities. So why wait? Embrace the power of no-code and propel your business to new heights today!</p>

This is expected behavior.
They are not replaced by comma. If you put the :split by into a text element, Bubble will show as a CSV (with a space) list, but this is a list, not a string.
So the comma doesn’t really exist.

What do you do after this operation?
Also, you can also consider using regex to split instead. But you may not need that too.


Yes, ‘split by’ removes the delimiter character (that’s how it works)….

The delimiter is used to delimit the texts. It’s not part of the text.

Can’t you just split by a line break in your case?

Or maybe use some regex?

1 Like

Thank you @Jici and @adamhholmes for the reply and thoughts.

Yes, not being replaced by comma. I see in the database, a comma, but that is simply showing the different list items…but the ‘split by’ is removing the designated delimiter.

What I ended up doing so to keep my delimiter in tact was to use the dynamic expression to have a find and replace operator which would find the <h2and I replaced it with {Header2}<h2 so that I could then use the split by operator (which does remove the delimiter) to split by {Header2} and then I was able to keep the <h2as I needed it.

I’m using some regex in this to remove the HTML tags, but not for splitting. I need to know which HTML tags are used, so I need to split before I use regex to remove the HTML tags.

I think I have got things put together after reading your replies.

Now just working my way through all the possible scenarios of the overall formatting of the HTML file to run my workflows removing what I need to save in the DB as I need it.

1 Like