Get the file name from given path

Get the file name from given path

Steps:

·         Copy the above below script and Execute the full script....

·         Run the below given script

Execute:
SELECT dbo.UDF_GET_SPECIFIC_STRING('c:\testing\name.txt')

-- The output will be "name.txt"

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = 'UDF_GET_FILE_NAME_FROM_GIVEN_PATH' AND TYPE = 'FN')
    DROP FUNCTION UDF_GET_FILE_NAME_FROM_GIVEN_PATH
GO

CREATE FUNCTION [dbo].[UDF_GET_FILE_NAME_FROM_GIVEN_PATH]
(@PS_String VARCHAR(1000))
RETURNS VARCHAR(256)
AS
/*       
----------------------------------------------------------------------------------------------------------------------------------------------------------------
    Description            :
                       Get the file name from given path
                     
    Input Parameter        : TEXT
                         
                 
    Return Value        : String

    --IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = 'UDF_GET_FILE_NAME_FROM_GIVEN_PATH' AND TYPE = 'FN')
    --    DROP FUNCTION UDF_GET_FILE_NAME_FROM_GIVEN_PATH
    --GO
----------------------------------------------------------------------------------------------------------------------------------------------------------------
    --Created By    : Karthikeyan Jothi
    --Created On    : 1/10/2014

    --USP : User Defined Function

    --- Changes Details
    ------------------------------------------------------------------------------------------------------------------------------------------------------------
    --S.no    Modified By            Modified On        Reason
    ------------------------------------------------------------------------------------------------------------------------------------------------------------

    -- Execution Part
    --====================
        Run the UDF with different test values
        SELECT dbo.UDF_GET_FILE_NAME_FROM_GIVEN_PATH('') AS 'EmptyString';
        O/P -> NULL
     
        SELECT dbo.UDF_GET_FILE_NAME_FROM_GIVEN_PATH('c:\testing\name.txt')
        O/P -> name.txt
     
        SELECT dbo.UDF_GET_FILE_NAME_FROM_GIVEN_PATH('c:\testing\tetsubfdsasbakjskanbsakbskas\eg.txt')
        O/p -> eg.txt
 
    --***********************************--
----------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
BEGIN
Declare     @output varchar(256)

    -- Best Way...
    IF LEN(@PS_String)> 0
    BEGIN
    SET @output = RIGHT( @PS_String, CHARINDEX( '\', REVERSE( @PS_String)) - 1)
    END
  
    return @output
END-------------------------------------------------------------------------------------------------------------------------

Thanks & Regards,

Karthikeyan Jothi.

"You Never Fail Until You Stop Trying"