Forum Discussion

joxe's avatar
joxe
Regular Visitor
5 years ago
Solved

How to divide a column keeping the delimiter?

Hello, When I divide a column by delimiter in the result the delimiter is lost. How can I keep it? Thanks.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You could use ReplaceValues and replace "<h3" with "<h3,", and then split using "," as the delimiter.
    --Nate

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi joxe 

 

Can you provide some sample data and expected result? Not sure what exactly you want...split it by delimiter then add it back?

 

 

joxe's avatar
joxe
Regular Visitor
5 years ago

Hi Vera,

I am working with the code of a web page. I need to split a column into rows each time the <h3 text appears, which usually goes in a sequence: <h3 class = "article__title">. Therefore:

 

 

But after the step I lose the delimiter and, as you can see, each row starts with class = "article__title", and not wiht <h3 class = "article__title">, as I need:

 

 

Do you know how to keep the delimiter?

 

Thank you very much.