Splitting of a String using query

Question

I wrote a query which splits a string and show me as a value I want using SUBSTR

    SELECT SUBSTR ('imagelocation/r1.jpg', 15)   AS image_location  FROM dual

I am getting the output as r1.jpg but I only want the value to come as r1. Please help

tvm · Accepted Answer · 2013-11-22 06:13:45Z

1

If you want something more universal, regexp_replace might be of use.

SELECT 
regexp_replace('imagelocation/r1.jpg','^[^/]*/([^.]+).*$','\1') AS image_location 
FROM dual;

edited Nov 22, 2013 at 6:13

answered Nov 22, 2013 at 6:07

tvm

3,45929 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mdahlman · Accepted Answer · 2013-11-22 07:30:15Z

1

select SUBSTR (
         'imagelocation/r1.jpg', 
         INSTR('imagelocation/r1.jpg', '/')+1,
         LENGTH('imagelocation/r1.jpg') - INSTR('imagelocation/r1.jpg', '.') - 1
       ) AS image_location  
FROM dual

SUBSTR Function in Oracle

SQL Fiddle

edited Nov 22, 2013 at 7:30

mdahlman

9,4104 gold badges49 silver badges75 bronze badges

answered Nov 22, 2013 at 6:01

Prahalad Gaggar

11.6k17 gold badges58 silver badges73 bronze badges

Comments

Armunin · Accepted Answer · 2013-11-22 08:01:16Z

0

Try this:

SELECT SUBSTR('imagelocation/r1.jpg',15,2) AS image_location FROM dual

edited Nov 22, 2013 at 8:01

Armunin

9967 silver badges18 bronze badges

answered Nov 22, 2013 at 6:05

user3020494

7326 silver badges9 bronze badges

Collectives™ on Stack Overflow

Splitting of a String using query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related