Wednesday, 12 July 2017
SQL - Parse HTML Data in Column
Answer
I have a column named "Message". In this column there is a data which is HTML code. I need to parse this HTML in SQL then split it 5 different column "Name" - "Surname" - "Email" - "Telephone" - "Message". Here is the HTML format that I need to parse;
NameSurname
kaydi peldi sord
Email
...@gmail.com
Telephone
535...5464
Message
Benfica-Fenerbahçe
First, split NameSurname to Name and Surname. The rule is split from last space (in this sample, it should "Name : ejder mehmet" , "Surname : sıkık", then insert other columns directly. How can I do that? Thanks for answers!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment