I am trying to parse the following string to extract database name (highlighted in RED)
00:00:00.437 - ToolId 140: Alias Translated to odb:Provide=SQLOLEDB.1; Initial Catalog=ReportingAnalytics;Data Source= XYZ,1234; Use Procedure for prepare=1 ...............................
Any leads will be highly appreciated.
Thank you
Solved! Go to Solution.
@khanp27 If the values you're trying to pull from this string are exactly 3 characters followed by a comma and 4 digits, this expression will work for you: .*(.{3}\,\d{4}).*
If not, I'd recommend checking out www.regex101.com so you can put in the actual values and find out what works best for you.
@khanp27 One way of doing this