SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RTRIM LTRIM Question

SophOct 4 2012 — edited Oct 5 2012

Hi,

I am trying to trim left and right characters to display only the email address data. the right '>' sign is good but the left ones I am having a problem with the date/time is changing. any idea please/

Used Query:

select rtrim(ltrim(email_addresses, '%RCPT TO:<'),'>'), email_addresses
from EPIMART.EMAIL_ADDRESSES_LISTX
where email_addresses like '%RCPT TO:<%'
group by EMAIL_ADDRESSES

Sample date:
At 2012-10-03 14:26:42.893: Sent: RCPT TO:<billflink@charter.net>
At 2012-10-03 14:26:46.989: Sent: RCPT TO:<aszymaszek@cox.net>
At 2012-10-03 14:26:45.356: Sent: RCPT TO:<artiebaehr@cox.net>
At 2012-10-03 14:26:49.000: Sent: RCPT TO:<larry_wolfgram@baxter.com>

Oracle Version

SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 4 08:31:28 2012

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Thanks,
Sof

Edited by: Soph on Oct 4, 2012 5:36 AM

This post has been answered by Sven W. on Oct 4 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 2 2012

Added on Oct 4 2012

10 comments

440 views