REGEXPR_SUBSTR returning too much data

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

5 replies [Last post]

Thu, 11/08/2012 - 7:30pm

Guest

I'm trying to use REGEXPR_SUBSTR to return ONLY the data after the = sign in my string. For example, the string is T34XH5=170. I only want 170. I can't figure out how to strip out the =. I have tried several iterations. My current one is:

REGEXP_SUBSTR('T34XH5=170','=[^FINAL]+')
What I get is =170. I just need 170. ?

I've also tried:
REGEXP_SUBSTR('T34XH5=170','=[^ ]') and get the same result.

My SQL skills are pretty remedial so I'm kind of grasping here.
Thanks!
M

Bookmark/Search this post with

Thu, 11/08/2012 - 7:31pm

Guest

Re: REGEXPR_SUBSTR returning too much data

Sorry.....that's REGEXP, not REGEXPR. See how remedial I am!!! :)

Tue, 12/11/2012 - 6:13am

Guest

Re: REGEXPR_SUBSTR returning too much data

Hiya,

Instr func should get you that, I do guess so....

Else give this a try,

SELECT SUBSTR('T34XH5=170.',8,12) FROM DUAL

Thanks,
RKO

Fri, 03/23/2018 - 2:39pm

Guest

Re: REGEXPR_SUBSTR returning too much data

Regexp_Substr('T34XH5=170', '\d{3}')

Fri, 03/23/2018 - 2:41pm

Guest

Re: REGEXPR_SUBSTR returning too much data

Regexp_Substr('T34XH5=170', '[^/=]+', 1, 2)

Fri, 03/23/2018 - 2:50pm

Guest

Re: REGEXPR_SUBSTR returning too much data

Regexp_Substr('T34XH5=170', '=(.*)', 1, 1, 'i', 1)

Post new comment

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>. The supported tag styles are: <foo>, [foo].

BBcode

You can use BBCode tags in the text.
Lines and paragraphs break automatically.
Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options

CAPTCHA

The question below is to prevent automated spam submissions.

Math question: * 1 + 18 =

Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Unanswered Forum Posts

Title	Under	Posted on
ADD 24 months starting from current month.(peoplesoft)	PeopleSoft Functional	07/29/2018 - 8:44pm
TRC values dropdown	PeopleSoft Technical	04/04/2018 - 12:54am
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode	PeopleSoft Technical	09/11/2017 - 4:49am
How to add custom process in Paycycle PeopleSoft Accounts payable.	PeopleSoft Technical	06/07/2017 - 4:39am

Main Menu

User login

Quick links

Sponsored links

Recent blog posts

Who's new