Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Well after giving the problem another look, I've come to believe that a combination of several sub-patterns going to do a better job then one mega-pattern. So I divided the pseudoUrlPattern into two, one for urls at the beginning of the line, and one for every other url in the given text. Consider the following revised code, complete with my testing text:</p> <pre><code> var doLinks = function(originalText) { var urlPattern = /[^&lt;&gt;]\b(?:https?|ftp):\/\/[a-z0-9-+&amp;@#\/%?=~_|!:,.;]*[a-z0-9-+&amp;@#\/%=~_|](?![^&lt;&gt;])/gim; var pseudoUrlPattern1 = /^([^\/])?(www\.[\S]+(\b|$|[^&lt;&gt;]))/gim var pseudoUrlPattern2 = /([^\/"&gt;&lt;])(www\.[\S]+(\b|$))(?![^&lt;&gt;])?/gim; var emailAddressPattern = /(([a-zA-Z0-9_\-\.]+)@[a-zA-Z_]+?(?:\.[a-zA-Z]{2,6}))+/gim; return originalText .replace(urlPattern, '&lt;a target="_blank" href="$&amp;"&gt;$&amp;&lt;/a&gt;') .replace(pseudoUrlPattern1, '$1&lt;a target="_blank" href="http://$2"&gt;$2&lt;/a&gt;') .replace(pseudoUrlPattern2, '$1&lt;a target="_blank" href="http://$2"&gt;$2&lt;/a&gt;') .replace(emailAddressPattern, '&lt;a target="_blank" href="mailto:$1"&gt;$1&lt;/a&gt;'); } var string = 'www.yahoo.com is a website just like &lt;a href="http://www.google.com"&gt;http://www.google.com&lt;/a&gt; and not like &lt;a href="www.facebook.com "&gt; www.facebook.com &lt;/a&gt; and not like www.example.com'; </code></pre> <p>give it a try, tell me how it went.</p> <p>one thing to pay attention to: the urls already in the anchor tags preferably should not have any spaces between the url and the tag.</p>
    singulars
    1. This table or related slice is empty.
    1. POReplace URLs (with links) BUT within text that already has some links defined
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USVlad Lyga
    1. USVlad Lyga
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COThanks for the quick answer!!! I will definitely give it a try!
      singulars
      1. PO
      1. USuser123456789
    2. COThe changes only partially work. Now the 2nd part of the sentence appears correctly, but the 1st part has been ignored and remains plain text. For instance the yahoo portion is still plain text, while the google portion has been untouched and remains a link (without the double tag). I need the yahoo portion to be a link AND the google portion untouched and without a double tag.
      singulars
      1. PO
      1. USuser123456789
    3. COOk, so I think I've got it right this time. Check out my edited answer with complete code example.
      singulars
      1. PO
      1. USVlad Lyga
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload