Re: Find the next word using regular expressions in Oracle 10g

From: <admin_at_rbtron.com>
Date: Mon, 9 Feb 2009 13:56:33 -0800 (PST)
Message-ID: <d43edc93-3d08-4f2a-92b4-9a818563020f_at_w34g2000yqm.googlegroups.com>



On Feb 9, 3:35 pm, ad..._at_rbtron.com wrote:
> Awesome answers! ... Thanks a lot ... just one more thing:
>
> Sometimes the file will have :
>
> (STATE_DETAILS = (STATE_NAME =
>                                       TEXAS)(ZIPCODE = 12345))
>
> or
>
> (STATE_DETAILS = (TERRITORY =
>                                       TEXAS)(ZIPCODE = 12345))
>
> So how to find the word after : either STATE_NAME or TERRITORY ?
>
> Thanx once again!
>
> -GC

Ok, I got that boolean part ... I modified it to [STATE_NAME | TERRITORY] and it worked fine ...

Two other things:

  1. Some files have Territory as US.TEXAS ... in such cases, the script outputs only US not US.TEXAS
  2. Some files don't have STATE_NAME or TERRITORY in them. I need to output the word NULL in such cases.

Thanks! Received on Mon Feb 09 2009 - 15:56:33 CST

Original text of this message