This discussion is archived
1 Reply Latest reply: Aug 21, 2013 2:16 PM by Frank Kulash RSS

Parse An Address String - Round 2

GMoney Newbie
Currently Being Moderated

All,

 

I am looking for a document or resource that will explain to me how to properly use REGEXP in a matter that I can understand.

I have looked at the Oracle documentation but other sources but what i really need is something that shows me step by step and what each of the special characters are doing.

 

For example

 

1234 DARK END ST

867 DARK ST

 

select
regexp_substr ('1234 dark end st','[[:digit:]]+') as nbr1,
regexp_substr ('867 DARK ST','[[:digit:]]+') as nbr2
from dual


which gives the desired result of  1234 and 867 respectively.

My issues is I do not know how to apply the other special characters that would allow me to manipulate the rest of the string.

 

I am looking for suggested reading or a website to learn from.

 

Thanks!

 

G

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points