How to extract custom tokens in SQL Server NVarChar/VarChar field by using RegEx?
- by Kthurein
Is there any way to extract the matched strings by using Regex in T-SQL(SQL Server 2005)?
For example:
Welcome [CT Name="UserName" /],
We hope that you will enjoy our services and your subscription will be expired on [CT Name="ExpiredDate" /].
I would like to extract the custom tokens in tabular format as follows:
[CT Name="UserName" /]
[CT Name="ExpiredDate" /]
Thanks for your suggestion!