[Solved] Using AWK to extract SQL result

Shell Programming and Scripting
1

I just wish to extract the result onli... but I dont which edit to perform to start from (**) :wall:
Current display result

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 24 14:14:49 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
 
Session altered.
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 (**)TFM021,2012-09-24 12:18:28,LOGON,TH19_6
TFM030,2012-09-24 10:29:46,LOGOFF,TH20_6
TFM034,2012-09-24 12:50:09,LOGON,TH19_34
TFM041,2012-09-24 07:25:10,LOGON,TD10_5
TFM043,2012-09-23 19:21:11,LOGOFF,TB15_0
2

try this..

sed '1,/SQL> SQL> SQL>/d' file
1 Like
3

i have the btm for this how wld i remove the btm till EOF..

sed 'SQL> SQL> SQL> D, eof? d' file ??

4

try this..

sed -n '/SQL> SQL> SQL>/,/SQL> SQL> SQL>/p' file
5

any it removed the whole line and also had removed my first data

---------- Post updated at 04:06 PM ---------- Previous update was at 03:39 PM ----------

thanks! Problem resolved

Solution is:
I applied

calc the no. of lines to remove

[closed]