提取文件中某一段内容

0 0

提取文件中某一段内容5

有一个文件里面是Sql的日志，里面记录了多个sql执行的结果，现在想解析出每个sql的文件路径、执行结果，文件内容如下：

1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 1> 2> ***[Modify]***begin to run: D:\CC\CME_Dev_vob\00 SRAN
Client\02
DB\Sybase\MBSC\MBSC6900V900R014C00SPC200\Rules\MO\GTRX.sql************
********
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> ***[Modify]***begin to run: D:\CC\CME_Dev_vob\00 SRAN
Client\02
DB\Sybase\MBSC\MBSC6900V900R014C00SPC200\Rules\MO\GTRXDEV.sql*********
***********
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table 'sp_Chk_GTRXDEV_RXUMODE_50'.
The stored procedure will still be created; however, it cannot be
successfully executed until the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure
because it depends on the missing table
'sp_Chk_GTRXDEV_RXURCVMODE_50'. The stored procedure will still be
created; however, it cannot be successfully executed until the table
exists.
1> 2> ***[Modify]***begin to run: D:\CC\CME_Dev_vob\00 SRAN
Client\02
DB\Sybase\MBSC\MBSC6900V900R014C00SPC500\Rules\MO\GTRX.sql************
********
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> ***[Modify]***begin to run: D:\CC\CME_Dev_vob\00 SRAN
Client\02
DB\Sybase\MBSC\MBSC6900V900R014C00SPC500\Rules\MO\GTRXDEV.sql*********
***********