asked on
Regular expression in oracle
I need a regular expression in sql that truncates everything after the dash and including the dash.
For example:
I have 49858974-94984985
result 49858974
I have found some examples but not exactly what I need.
For example:
I have 49858974-94984985
result 49858974
I have found some examples but not exactly what I need.
Oracle Database
Last Comment
Sujith
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I think this will work. I will let you know the results on Monday. Thank you.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
hmmm. do we really need regular expression? would a plain substr not be more efficient?
just curious:
just curious:
select substr(yourfield, 0, instr(yourfield || '-', '-')-1) from yourtable
ASKER
Thanks angelIII
The problem with the instr code you gave me is if the number starts with -
then nothing is returned.
The reg. exp. still retuns the number after the -.
The problem with the instr code you gave me is if the number starts with -
then nothing is returned.
The reg. exp. still retuns the number after the -.
>>if the number starts with -
This is a new requirement. Do you have any other requirements that you have not mentioned?
Would you not want the '-' returned?
If so try:
regexp_substr('-49858974-9
This is a new requirement. Do you have any other requirements that you have not mentioned?
Would you not want the '-' returned?
If so try:
regexp_substr('-49858974-9
have you tried my post
SQL> select regexp_substr('-49858974-94984985', '[^-]+') from dual;
REGEXP_S
--------
49858974
SQL> select regexp_substr('49858974-94984985', '[^-]+') from dual;
REGEXP_S
--------
49858974
SQL> select regexp_substr('49858974-', '[^-]+') from dual;
REGEXP_S
--------
49858974
SQL>