locked
How I can create table by splitting all H1 followed by text until next H1 RRS feed

  • Question

  • User-1571110992 posted

    Hi All 

    I have data field contain following data 

    <h1> title1 </h1> some text 1 <h1> title2 </h1> some text 2 <h1> title3 </h1> some text 3

    I want to create table  of element which will contain 

    <h1> title1 </h1> some text 1
    <h1> title2 </h1> some text 2 
    <h1> title3 </h1> some text 3
    Wednesday, July 20, 2016 6:30 PM

Answers

  • User269602965 posted

    Idea

    Use .NET to read the column row by row

    parse at binary level to with SPLIT function into an array or list

    then loop the array and list and INSERT data into your new table

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 21, 2016 11:35 PM
  • User-1571110992 posted

    http://forums.asp.net/t/2099716.aspx?How+I+can+create+array+by+splitting+all+H1+followed+by+text+until+next+H1+

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 28, 2016 2:19 PM

All replies

  • User269602965 posted

    what database is the data field in?

    Thursday, July 21, 2016 1:56 AM
  • User-1571110992 posted

    Thank you for Replay .. The data base is SQL. and field is varchar(max)

    Thursday, July 21, 2016 2:07 PM
  • User269602965 posted

    Idea

    Use .NET to read the column row by row

    parse at binary level to with SPLIT function into an array or list

    then loop the array and list and INSERT data into your new table

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 21, 2016 11:35 PM
  • User-1571110992 posted

    http://forums.asp.net/t/2099716.aspx?How+I+can+create+array+by+splitting+all+H1+followed+by+text+until+next+H1+

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 28, 2016 2:19 PM