Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hierarchical SQL Select
Message
From
07/09/2009 14:14:57
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01422513
Message ID:
01422970
Views:
57
>>>>I believe the ut could easily 'recognize' those. It's just a matter of changing a regex imo
>>>
>>>What regex would you suggest?
>>
>>One that does not stop before a closing parenthesis
>>
>>
>>Compare
>> http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx
>> http://msdn.microsoft.com/en-us/library/aa172799SQL.80.a
>>
>>and
>>http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).aspx
>>http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).a
>
>What about
>(http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx)
>(http://msdn.microsoft.com/en-us/library/aa172799SQL.80.a)

Ok, I see the point

Still, you can make a pattern that does not accept a ) as the last char.. Something like
((http[s]?|ftp)://[\w/.()-]+[\w/.(-])
it will match
http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).aspx

and 
http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx

in 

(http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx)
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform