sql - Extract string after specific data occurrence -

sql - Extract string after specific data occurrence -

i have next string varies in length depending on database , table name:

[servername].[databasename].[dbo].[tablename.csv]

i extract table name after "[dbo]." , before ".csv]".

any help appreciated.

declare @str varchar(200) = '[servername].[tablename].[dbo].[tablename.csv]' select substring(@str,(patindex('%dbo%',@str)+6), (patindex('%.csv%', @str) - (patindex('%dbo%',@str)+6)))

sql string