Post reply

can''t get substring filename!

  • March 3, 2006 at 12:07 pm

    #189550

    Does anyone know how to extract only the file name (resume.doc) from a string like this:

    C:\Documents and Settings\User1\Desktop\resume.doc 

    thanks for any assistance....

    kristin

     

     

    Kristin

  • March 3, 2006 at 12:16 pm

    #624698

    declare @test-2 varchar(1000), @check int

    set @test-2 = 'C:\Documents and Settings\User1\Desktop\resume.doc'

    set @check = charindex('\', @test-2, 0)

    while @check <> 0

      begin

      set @test-2 = right(@test, len(@test) - @check)

       set @check = charindex('\', @test-2, 0)

      end

    select @test-2

  • March 3, 2006 at 1:12 pm

    #624720

    Or, if you want to do it in one expression, it's easy if you reverse the string:

    REVERSE(SUBSTRING(REVERSE(@test),1,charindex('\',reverse(@test))-1))

     



    Mark

  • March 3, 2006 at 1:37 pm

    #624724

    LOL...that would be easier.

  • March 3, 2006 at 2:06 pm

    #624736

    yeah, that was easier, works perfect thank you so much

    Kristin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply