Transforming string for ImagePath

Question

Post reply

Transforming string for ImagePath

luissantos

SSCertifiable

Points: 7391
More actions
November 21, 2010 at 3:59 pm

#231793

Hello comunity
I would like to know how to transform my imagepath from :
C:\PROGRAM FILES\DYNAMIC AI\DLCL\IMAGES\IMG00011-20101109-1310.JPG
first , i change the "\" to "/" with this query :
SELECT REPLACE(st.imagem,'\','/') FROM st WHERE ref LIKE 'RESC%'
The result is :
C:/PROGRAM FILES/DYNAMIC AI/DLCL/IMAGES/IMG00011-20101109-1310.JPG
Now ,after changing the "\" to "/" , i want in my SELECT keep only at this point:
/IMAGES/IMG00011-20101109-1310.JPG
i mean i need to begin to the right, to find "/IMAGES/%" and ignore "C:/PROGRAM FILES/DYNAMIC AI/DLCL".
Can someone give me some help.
Many thanks and best regards
Luis Santos
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Simply this...?

SELECT SUBSTRING(REPLACE(st.imagem,'\','/'),

PATINDEX('%\IMAGES\%',st.imagem),

LEN(st.imagem))

FROM st WHERE ref LIKE 'RESC%'

and st.imagem like '%\IMAGES\%'

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

luissantos SSCertifiable Points: 7391 More actions · Answer 2

luissantos

SSCertifiable

Points: 7391

November 21, 2010 at 4:09 pm

#1253535

Many thanks

That´s work fine.

Best regards

Luis Santos

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

And, apparently, the REPLACE is not necessary. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mister.magoo SSC-Forever Points: 47174 More actions · Answer 4

Jeff Moden (11/21/2010)
And, apparently, the REPLACE is not necessary. 😉

I just cricked my neck watching that one fly overhead 😀

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);