User login
Sponsored links
Recent blog posts
- How to resubmit on Integration Broker message with DONE status
- Message cannot be changed. Message referenced in runtime tables (Doc ID 660969.1)
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
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.
REGEXPR_SUBSTR returning too much data
Thu, 11/08/2012 - 7:30pm
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
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
| Search Results | PeopleSoft Technical | 11/15/2017 - 10:24am |
| PS Query - Need Dependency and Prunable examples | PeopleSoft Technical | 10/19/2017 - 11:28am |
| how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Stay updated
CompShack is a user driven Dev2Dev IT community. Developers can ask questions, help answer questions, or just browse code and articles contributed by users. No registration required.
You can register if you want to contribute code samples, share your knowledge at your own blog, and become adored in the community!
Poll
New forum topics
- TRC values dropdown
- OHS is rendering XML instead of the view or data
- Search Results
- PS Query - Need Dependency and Prunable examples
- PS HCM AWE - Transaction routing to Requestor for approval, when he is the Delegatee by his 1 up Manager
- how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode
- How to add custom process in Paycycle PeopleSoft Accounts payable.
- How to Pass XML String in SOAPDoc Parm
Recent comments
- Re: Invalid SNAC client version
5 days 8 hours ago - Re: Trace Application Engine Processes Using Process Definitions
6 weeks 3 days ago - Re: Mutliple Values For Prompts in PS Query
8 weeks 4 days ago - Re: REGEXPR_SUBSTR returning too much data
13 weeks 2 days ago - Re: REGEXPR_SUBSTR returning too much data
13 weeks 2 days ago - Re: REGEXPR_SUBSTR returning too much data
13 weeks 2 days ago - Re: Send Emails from PeopleCode (SendMail Function)
17 weeks 6 days ago - Re: Instr function in SQR
19 weeks 5 days ago - Re: Mutliple Values For Prompts in PS Query
20 weeks 2 days ago - Re: Expense -Not able to stage expense for Pay Cycle Processing
22 weeks 2 days ago
Sorry.....that's REGEXP, not REGEXPR. See how remedial I am!!! :)
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
Regexp_Substr('T34XH5=170', '\d{3}')
Regexp_Substr('T34XH5=170', '[^/=]+', 1, 2)
Regexp_Substr('T34XH5=170', '=(.*)', 1, 1, 'i', 1)
Post new comment