Sign in to follow this  
Followers 0
DjDeep00

Reg Exp Help

3 posts in this topic

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;

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by ascendant

Share this post


Link to post
Share on other sites

Didnt know it was that easy...

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0