How to Extract part of a string 1

[Andel]

For example, I have the following string:

"H:\SQL\DATA\Customer_data.dat"
"O:\SQL\LOG\Customer_log.dat"

I only want to get the "Customer_data.dat" and "Customer_log.dat". In other words, I want to exclude the drive letter and directories.

Is there a way I can do that? Thanks in advance! Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[anhmytran]

I do not know if SQL Server has syntax like VB or not.
In VB you may use InStrRev() function to determine how many characters
from the beginning of the string to the last "\", then use the Right() function
to extract the string you need which has the length calculated by the Len() function.
For example:
strA = "D:\asdg\asdg\sadg\asdg\adsg\agds\adsg\adsg\agds\agds\whatever.ext"
strB = Right(strA, Len(strA) - InStrRev(strA, "\&quot)
The return value for strB is "whatever.ext"

 

[foxdev]

In SQL Server you can use the REVERSE, CHARINDEX and SUBSTRING functions to get what you need. I would supply an example, but its too late in the day and my brain is fried. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[Andel]

I got it... thanks for the clue Robert!

declare @filename varchar(30)
set @filename = 'H:\SQL\DATA\Customer_data.dat'
select reverse(substring(reverse(@filename), 1, charindex('\', reverse(@filename)) -1))

Andel
andelbarroga@hotmail.com

http://andyb.8m.com