Best way to add target ='_blank' for href in a string using UDF

Question

I've got data in sql server 2012 that contains text with links <a href="test/test">test </a> with out target i need to add target for the string data. I need to create a User defined function for that. Does any one have any sample code for this.

Example text -

If you've ever thought one of your text message threads was so good it deserved to be published, you may be on to something.view. <a href="/apple/sdffsd/sdffs">njkhj </a> In future iterations, users will be able to post .<br><br>You may update your email address at any time by going to <a href="/apple/fafasdf/sdfsdf">sdffsd</a>. Our whole goal is to have the reader go through an entire narrative arc in five minutes and consume it in a way that's native to mobile," says Gupta go to <a href="/a/s/sdfsf"> sdfsdf </a> which is one of my favorite books, is told as letters back and forth between the two main

What have you researched, tried, and found to not work? SO is not a place where you ask for a tailored solution while showing zero effort on your part. — dfundako, Oct 10 '16 at 13:52
As the `target='_blank'` is useless outside a browser, could you not manage that in your application ? Something like that : http://stackoverflow.com/questions/7901679/jquery-add-target-blank-for-outgoing-link ? — Raphaël Althaus, Oct 10 '16 at 14:01

score 1 · Accepted Answer · answered Oct 10 '16 at 14:07

1

I think a simple replace would do the trick

Declare @String varchar(max) = 'Some large text with a <a href="test/test">link</a> to content'

Select Replace(@String,' href=','_target="blank" href=')

Returns

(No column name)
Some large text with a <a _target="blank" href="test/test">link</a> to content

answered Oct 10 '16 at 14:07

John Cappelletti

79,615
7
44
66

Thank you. I thought the same... I realized that i was over complicating things and just needed to think simple. – Nethra Oct 10 '16 at 15:05
@akki Always too easy to over think things – John Cappelletti Oct 10 '16 at 15:06
Did not use stack over flow a lot , where can i mark it as answered? – Nethra Oct 10 '16 at 15:11
@akki near the Up/Down Vote – John Cappelletti Oct 10 '16 at 15:14

score 0 · Answer 2 · answered Oct 10 '16 at 15:08

0

We can also use SELECT REPLACE(text,'<a','<a target="_blank" '); Go

answered Oct 10 '16 at 15:08

Nethra

51
4

Best way to add target ='_blank' for href in a string using UDF

2 Answers2