Reg Exp Help

[DjDeep00]

Can anyone help me return only the state from the following using the REGEXP_SUBSTR function in oracle?

Data:

NEWTON FALLS OHIO 44444-9416

CAPE CORAL FL 33914-6428

This is what I have:

SELECT REGEXP_SUBSTR('CAPE CORAL FL 33914-6428',
'+ [^-]+ ')
FROM DUAL;

[Ascend4nt]

hmm, no idea how Oracle works. You do know this is an AutoIT forum right?

If you were using AutoIT, this expression would work:

\s(\w+)\s\d

Edited March 25, 2009 by ascendant

[DjDeep00]

Didnt know it was that easy...

SELECT REGEXP_SUBSTR('CAPE CORAL FL 33914-6428','[^ ]+', 1, 3)  FROM DUAL;