Pull name of pdf from column

[jasonhuibers]

Table = Employees
Column1 =

https://ebay.com/sec/EmployeeName.pdf

Using a SELECT statement I want to return the name of the pdf file from Column1 (ie: EmployeeName.pdf)

How can I do this using a SELECT statement

 

[carp]

Jason -
Can you tell us what you've tried so far?
If you use INSTR to find the position of the last "/", you can then use SUBSTR to get everything after that position.

 

[SantaMufasa]

Building upon Carp's excellent suggestion:

select * from jason;

COLUMN1
-------------------------------------
[URL unfurl="true"]https://ebay.com/sec/EmployeeName.pdf[/URL]

1 row selected.

select substr(column1,instr(column1,'/',-1)+1) results from jason;

RESULTS
----------------
EmployeeName.pdf

1 row selected.

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[jasonhuibers]

I used this: it worked for me...
SELECT SUBSTR(it.comments , INSTR(it.comments,'/', -1, 1)+1)
FROM Feedback it;