String Parsing

[khanp27]

I am trying to parse the following string to extract database name (highlighted in RED)

00:00:00.437 - ToolId 140: records were written to Cloudera ODBC (db.table_name)

00:00:00.927 - ToolId 228: records were written to XYZ Reporting Analytics SP (dbo.XYZ)

00:00:00.373 - ToolId 273: File successfully uploaded to test.com (file is abc.hyper) 00:00:14.524 - .........

00:00:00.567 - ToolId 238: File successfully uploaded to test1.com(file is xyz.hyper) 

Any leads will be highly appreciated. 

Thank you

[MilindG]

@khanp27 

[caltang]

You can also try this @khanp27 

.* to (.*\))