carlino70
asked on
How to delete a space and the string after space, in a entire column ?
Helo, could you help me with the next issue?
I need delete a first space and the string after their space, in a entire column
Example with just a row:
Thank in advanced!
I need delete a first space and the string after their space, in a entire column
Example with just a row:
select pointname
from from_ap
where pointname like 'AER_4L_SA6____I%';
say:AER_4L_SA6____I Corriente Sal.06 33kV
I want:AER_4L_SA6____I
It is possible to do using SUBSTR, INSTR or regular expressions, in every column 'pointname'?Thank in advanced!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works.
Thanks to both!
Thanks to both!
regexp_substr(pointname,'^