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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
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 |
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)