Title |
Test
Find
Pattern Title
|
Expression |
(?:Provider="??(?<Provider>[^;\n]+)"??[;\n"]??|Data\sSource=(?<DataSource>[^;\n]+)[;\n"]??|Initial\sCatalog=(?<InitialCatalog>[^;\n]+)[;\n"]??|User\sID=(?<UserID>[^;\n]+)[;\n"]??|Password="??(?<Password>[^;\n]+)"??[;\n"]??|Integrated\sSecurity=(?<IntegratedSecurity>[^;\n]+)[;\n]??|Connection\sTimeOut=(?<ConnectionTimeOut>[^;\n]+)[;\n"]??)+$ |
Description |
This RegExp is degigned to mach SQL OLEDB Connection String to the Named Groups Properties useful for .Net MATCH EXAMPLE(the submition field is too short):Provider="SQLOLEDB.1";Data Source=(local);Initial Catalog=master;User ID=sa;Password="SA_PASS";Connection TimeOut=90 |
Matches |
Provider="SQLOLEDB.1";Data Source=(local);Initial Catalog=master;User ID=sa;Password=" |
Non-Matches |
Any non SQL Connection String |
Author |
Rating:
Jordan Ilchev
|
Source |
|
Your Rating |
|
Title: Re: Fails if quoted item contains a semicolon
Name: Jordan Ilchev
Date: 2/16/2005 4:17:22 AM
Comment:
no the issue seems to be in
Password='a;s"dasd'
You may change the RegExp for Password replace
Password="??(?<Password>[^;\n]+)"??[;\n"]??
to:
Password='??(?<Password>[^;\n]+)'??[;\n']??
to use single quotes
Title: Fails if quoted item contains a semicolon
Name: Clinton
Date: 2/14/2005 10:49:27 AM
Comment:
Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password='a;s"dasd';