asked on 9/12/2013

Another string manipulation

I have a string that has a network path aloing with a filename assigned to it.
'\\dev01\company011\_fileserver\content\Image\VCSJK_1bd00b4f-c26e-4d01-84c6-d0848aa258d5_concert.jpg'

I need the filename stripped from the string
'VCSJK_1bd00b4f-c26e-4d01-84c6-d0848aa258d5_concert.jpg'

I am trying to get everything from the right of 'Image\' but I figured Id post it as well

Thats it!!

Thanks

Databases Oracle Database SQL

Last Comment

jknj72

9/12/2013

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

9/12/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Sean Stuber

9/12/2013

REGEXP_SUBSTR(
'\\dev01\company011\_fileserver\content\Image\VCSJK_1bd00b4f-c26e-4d01-84c6-d0848aa258d5_concert.jpg',
'[^\]+$'
)

Aneesh

9/12/2013

declare @string varchar(1000) = '\\dev01\company011\_fileserver\content\Image\VCSJK_1bd00b4f-c26e-4d01-84c6-d0848aa258d5_concert.jpg'

SELECT REVERSE( LEFT( reverse (@string),CHARINDEX('\', reverse (@String) )-1) )

slightwv (䄆 Netminder)

9/12/2013

aneeshattingal,

Oracle Zone implies Oracle solution...

jknj72

9/12/2013

ASKER

thanks again