I need to get the text between html tags in SQL.
< em> " **Test,Extract Me** " < /em>
This is just a small part of html body where the unique identifier is < em>"
Please help
-
earlier you added the tag with HTML.Now you are tagging with sql server. What is the issue. Please explain properDeepak Kumar– Deepak Kumar2018-08-07 06:48:07 +00:00Commented Aug 7, 2018 at 6:48
-
If you're using sql server, it has its own xml query syntax... learn.microsoft.com/en-us/sql/t-sql/xml/…MatBailie– MatBailie2018-08-07 07:14:14 +00:00Commented Aug 7, 2018 at 7:14
Add a comment
|
4 Answers
SELECT SUBSTRING(ColumnName,CHARINDEX('html_tag',ColumnName)+LEN('html_tag'),CHARINDEX('html_close_tag',ColumnName)-LEN('html_close_tag')) FROM TableName
please replace html_tag,html_close_tag with your tags.
8 Comments
RISHI
<h3 class="lead editable" id="intro" style='font-family:"HelveticaNeue-Light", "Helvetica Neue Light", "Helvetica Neue", Helvetica, Arial, "Lucida Grande", sans-serif; line-height:1.1; margin-bottom:15px; color:#000; font-weight:500; font-size:27px'> <em>"Test 3 response again "</em></h3>
RISHI
I want to extract Test 3 response again
RISHI
Please check the Syntax
Sajith v
SELECT SUBSTRING(ColumnName,CHARINDEX('html_tag',ColumnName) + LEN('html_tag'),CHARINDEX('html_close_tag',ColumnName) -CHARINDEX('html_tag',ColumnName) - LEN('html_close_tag')) FROM TableName
Sajith v
You can use like this SELECT REPLACE( SUBSTRING(ColumnName,CHARINDEX('html_tag',ColumnName) + LEN('html_tag'),CHARINDEX('html_close_tag',ColumnName) -CHARINDEX('html_tag',ColumnName) - LEN('html_close_tag')) FROM TableName), ' " ',' ') Is this enough to solve your problem?
|
I think you want to take a substring of the column value. You can try something like this:
SELECT SUBSTRING(ColumnName, 5, LEN(ColumnName) - 5) AS TrimmedValue FROM TABLE;
Comments
SELECT SUBSTRING(ColumnName,CHARINDEX('html_tag',ColumnName)+LEN('html_tag'), CHARINDEX('html_close_tag',ColumnName) - CHARINDEX('html_tag',ColumnName) - LEN('html_close_tag') +1) FROM TableName
In case the marked answer query doesn't work.
Comments
With using JQUERY you can find easily with simple one line of code :
$('em').text();
You can do the same with simple JS as well
document.getElementsByTagName('em')[0].innerText
1 Comment
gthuo
While possibly helpful in other scenarios, This is not an SQL query!