求助 文件字符串查找

lifeexpert

有一文件内容如下：(Text开头的都是一行)结果最好能按照  Elapsed Execution Time的后面的时间大小排列
Text     : CALL SYSIBM.SQLTABLES(?,?,?,?,?)
  Internal rows deleted: 0
  Internal rows updated: 0
  Internal rows inserted: 0
  Bufferpool data logical reads: 0
  Bufferpool data physical reads: 0
  Bufferpool temporary data logical reads: 0
  Bufferpool temporary data physical reads: 0
  Bufferpool index logical reads: 0
  Bufferpool index physical reads: 0
  Elapsed Execution Time:  0.000012 seconds

  Text     : SELECT CAST( NULL AS VARCHAR(12 ) AS TABLE_CAT, RTRIM(T.CREATOR) AS TABLE_SCHEM, T.NAME AS TABLE_NAME, CASE WHEN T.TYPE='T' AND T.CREATOR='SYSIBM' THEN 'SYSTEM TABLE' WHEN T.TYPE='T' AND T.CREATOR<>'SYSIBM' THEN 'TABLE' WHEN T.TYPE='V' AND T.STATUS<>'X' THEN 'VIEW' WHEN T.TYPE='V' AND T.STATUS='X' THEN 'INOPERATIVE VIEW' WHEN T.TYPE='X' THEN NULL WHEN T.TYPE='N' THEN 'SYNONYM' ELSE TT.TABLE_TYPE END AS TABLE_TYPE, T.REMARKS FROM SYSIBM.SYSTABLES T, SYSIBM.SQLTABLETYPES TT WHERE T.TYPE = TT.TYPE AND T.CREATOR = 'PBCATOWN' AND T.NAME = 'pbcattbl' ORDER BY 4,1,2,3
Internal rows deleted: 0
  Internal rows updated: 0
  Internal rows inserted: 0
  Bufferpool data logical reads: 0
  Bufferpool data physical reads: 0
  Bufferpool temporary data logical reads: 0
  Bufferpool temporary data physical reads: 0
  Bufferpool index logical reads: 0
  Bufferpool index physical reads: 0
  Elapsed Execution Time:  0.000232 seconds

Text     : SELECT CAST( NULL AS VARCHAR(12 ) AS TABLE_CAT, RTRIM(T.CREATOR) AS TABLE_SCHEM, T.NAME AS TABLE_NAME, CASE WHEN T.TYPE='T' AND T.CREATOR='SYSIBM' THEN 'SYSTEM TABLE' WHEN T.TYPE='T' AND T.CREATOR<>'SYSIBM' THEN 'TABLE' WHEN T.TYPE='V' AND T.STATUS<>'X' THEN 'VIEW' WHEN T.TYPE='V' AND T.STATUS='X' THEN 'INOPERATIVE VIEW' WHEN T.TYPE='X' THEN NULL WHEN T.TYPE='N' THEN 'SYNONYM' ELSE TT.TABLE_TYPE END AS TABLE_TYPE, T.REMARKS FROM SYSIBM.SYSTABLES T, SYSIBM.SQLTABLETYPES TT WHERE T.TYPE = TT.TYPE AND T.CREATOR = 'PBCATOWN' AND T.NAME = 'pbcattbl' ORDER BY 4,1,2,3
Internal rows deleted: 0
  Internal rows updated: 0
  Internal rows inserted: 0
  Bufferpool data logical reads: 0
  Bufferpool data physical reads: 0
  Bufferpool temporary data logical reads: 0
  Bufferpool temporary data physical reads: 0
  Bufferpool index logical reads: 0
  Bufferpool index physical reads: 0
  Elapsed Execution Time:  0.000422 seconds


RESULT:

Text     : CALL SYSIBM.SQLTABLES(?,?,?,?,?)
Elapsed Execution Time:  0.000012 seconds
Text     : SELECT CAST( NULL AS VARCHAR(12 ) AS TABLE_CAT, RTRIM(T.CREATOR) AS TABLE_SCHEM, T.NAME AS TABLE_NAME, CASE WHEN T.TYPE='T' AND T.CREATOR='SYSIBM' THEN 'SYSTEM TABLE' WHEN T.TYPE='T' AND T.CREATOR<>'SYSIBM' THEN 'TABLE' WHEN T.TYPE='V' AND T.STATUS<>'X' THEN 'VIEW' WHEN T.TYPE='V' AND T.STATUS='X' THEN 'INOPERATIVE VIEW' WHEN T.TYPE='X' THEN NULL WHEN T.TYPE='N' THEN 'SYNONYM' ELSE TT.TABLE_TYPE END AS TABLE_TYPE, T.REMARKS FROM SYSIBM.SYSTABLES T, SYSIBM.SQLTABLETYPES TT WHERE T.TYPE = TT.TYPE AND T.CREATOR = 'PBCATOWN' AND T.NAME = 'pbcattbl' ORDER BY 4,1,2,3
Elapsed Execution Time:  0.000232 seconds
Text     : SELECT CAST( NULL AS VARCHAR(12 ) AS TABLE_CAT, RTRIM(T.CREATOR) AS TABLE_SCHEM, T.NAME AS TABLE_NAME, CASE WHEN T.TYPE='T' AND T.CREATOR='SYSIBM' THEN 'SYSTEM TABLE' WHEN T.TYPE='T' AND T.CREATOR<>'SYSIBM' THEN 'TABLE' WHEN T.TYPE='V' AND T.STATUS<>'X' THEN 'VIEW' WHEN T.TYPE='V' AND T.STATUS='X' THEN 'INOPERATIVE VIEW' WHEN T.TYPE='X' THEN NULL WHEN T.TYPE='N' THEN 'SYNONYM' ELSE TT.TABLE_TYPE END AS TABLE_TYPE, T.REMARKS FROM SYSIBM.SYSTABLES T, SYSIBM.SQLTABLETYPES TT WHERE T.TYPE = TT.TYPE AND T.CREATOR = 'PBCATOWN' AND T.NAME = 'pbcattbl' ORDER BY 4,1,2,3
Elapsed Execution Time:  0.000422 seconds

blackold

要干吗啊？

lifeexpert

text内容执行时间长短

cxfcxf

我帮你-v-

1. 
   
2. #!/usr/bin/env ruby -w
   
3. 
   
4. hash = {}
   
5. 
   
6. File.open("whatever").each("Text") do |line|
   
7.   value1 = String.new
   
8.   key = String.new
   
9.   value2 = String.new
   
10.   value1 = "Text    #{$&}" if line =~ /\:.*?\n/
    
11.   key, value2 = $1, $& if line =~ /Elapsed.*?(\d+).*/
    
12.   (hash[value1] ||= [])  << (value1 + value2)
    
13. end
    
14. 
    
15. 
    
16. hash.keys.sort.each do |key|
    
17.   puts hash[key]
    
18. end
    

复制代码

liying_gg

你要是高圆圆就好了。

lifeexpert

谢了 ，我是用liunx shell，不好用，执行不了

cxfcxf

装个ruby好莱 要么我帮你翻译成perl....-_-

cxfcxf

1. 
   
2. #!/usr/bin/perl
   
3. 
   
4. my %hash;
   
5. $/ = "Text";
   
6. 
   
7. while (<>) {
   
8.         chomp;
   
9.         my $value1 = "Text    $&" if /\:.*?\n/;
   
10.         my ($key, $value2) = ($1, $&) if /Elapsed.*?(\d+).*/;
    
11.         push @{$hash{$key}}, "${value1}${value2}\n\n";
    
12. }
    
13. 
    
14. foreach (sort {$a <=> $b} keys %hash) {
    
15.         print "@{$hash{$_}}\n";
    
16. }
    

复制代码

写好文件 然后执行 ./script filename