Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Extracting values to right of strings? Regex?

Extracting values to right of strings? Regex?

From: jobs <jobs_at_webdos.com>
Date: Tue, 21 Aug 2007 14:18:15 -0700
Message-ID: <1187731095.416205.173930@d55g2000hsg.googlegroups.com>


Hello, oracle noob here.

I've got a function that returns a string that looks like this

Merchant Reference Code:610015
Request ID: 1877300000090176174087
Authorized Amount: 5.00
Authorization Code: 123456
Authorization Time: 2007-08-21T21:01:39Z --- end

What's the best way in Oracle to return values for some of these strings?

for example, If the string contains the string "ACCEPT - " , set variable status to true, esle false

variable amount = numeric to the right of Authorized Amount, so amount = 5.00

Thanks for any help or information! Received on Tue Aug 21 2007 - 16:18:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US