Yeah... Agree...

Awesome!!!

Very nice to understand.

But,I do not want to to hard code value 12 and 8. This is what i used that Reverse function.

(Sometime there is a chance in the filename...

• This reply was modified 4 years, 11 months ago by  parmsivan.kannan.

DECLARE @Text nvarchar(250) = '\\ABC.dns.com\file_path1\filepath2\inc_files_20200122.xls'

SELECT SUBSTRING(REVERSE(@Text),CHARINDEX('.',REVERSE(@Text))+1,CHARINDEX('_',REVERSE(@Text))-CHARINDEX('.',REVERSE(@Text))-1)

Hi

Thanks