I have routine which connects to database and gets the result. My output from the routine looks like:
Code: Select all
Ans =
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 18 06:43:41 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>
EMAILID
--------------------------------------------------------------------------------
Aquilis@yahoo.com
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
.
Aquilis@yahoo.com
So what would be the Server functions so that i can achieve the required output : "Aquilis@yahoo.com"
I have tried with following function:
Ans=trimF(trim(Field(Field(Output,'>',2),'',1),'-','A'))
but i am able achieve upto :
Code: Select all
Ans =
EMAILID
Aquilis@yahoo.com
SQL
I appreciate if you guyz suggest me any better approach Or suggest me how to remove Line Feed characters "\n".