I am trying to extract the state from an address where everything is in one column, heres an example:
2901 MAIN ST,CORNING,NY,14830
I have been trying to figure out how to do it with the substr
and instr
together, but I cant seem to get the hang of instr
. Here is what I have so far:
select substr('hello,hello,NY,11725-1234',1,instr('hello,hello,NY,11725-1234',',',2,3))
from dual;
I thought it would start at the second comma and end at the 3rd and get my everything in between, but that doesnt seem to be the case.
Any help is appreciated.
See Question&Answers more detail:os