How to remove the table tr td in sql server

narasiman rao

8y1.2k

i have one table in that table i have one column in that record as follows

SummaryList record as follows

Report Date : 2016-11-21	Optometrist :	Start Time :
Consultant : Dr.Suresh

i want to remove table tr td and i want only content as follows

from the above i want output as follows

Report Date: 2016-11-21 Optometrist: start Time: Consultant: Dr.suresh

for that how to do using sql server

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo8y ago
Report Date: 2016-11-21 Optometrist: start Time: Consultant: Dr.suresh
0
Midhun Tp8y ago
Hi,

Please try below query -
DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">

"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
   Report Date : 2016-11-21
  Optometrist :
  Start Time :


"COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
        Consultant : Dr.Suresh


table>'

SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)
Reference :
https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string
0