☰

Arquivo de log:

tag-icon • tag-icon text-processing
Arquivo de log:

1) Eu tenho um arquivo de log chamado version.txt e preciso filtrar todas as palavras com a palavra-chave "took ? ms".. O número antes de ms ("took ?? ms") varia para cada entrada de log.

A saída deve ser a seguinte:

took 4 ms
took 3 ms
took 4 ms
took 5 ms

2) Também é possível listar os resultados> 100. ou seja. deve listar valores superiores a 100. A saída deve ser semelhante;

took 100 ms
took 110 ms
took 450 ms

Arquivo de log:

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-32] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 4 ms** key: I,748518,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=100, buffer_22=-1] writeToCassandra: true

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-10] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 3 ms** key: I,26221,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=-29, damaged_3=-1] writeToCassandra: true

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-13] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 4 ms** key: I,960808,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=14] writeToCassandra: true

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-30] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 5 ms** key: I,771963,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=64, buffer_22=-1] writeToCassandra: true


2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-30] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 100 ms** key: I,771963,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=64, buffer_22=-1] writeToCassandra: true

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-30] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 110 ms** key: I,771963,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=64, buffer_22=-1] writeToCassandra: true

2020-03-11 06:19:29.857  INFO 29371 --- [  async-task-30] c.l.s.mapstore.InventoryPictureMapStore  : InventoryPictureMapStore.store() called **took 400 ms** key: I,771963,00000,00000,595 Value: InventoryPicture [, sourcingEnabled=false, itemType=1, onHand_1=64, buffer_22=-1] writeToCassandra: true

Responder1

Isso você pode tentar:

grep -oP "took [[:digit:]]{3,} ms" file

Saída:

took 100 ms
took 110 ms
took 400 ms

Obrigado. é possível listar a data/hora também? algo assim como saída:

11-03-2020 06:19:29.857 demorou 100 ms

11/03/2020 06:19:29.857 demorou 110 ms

Supondo que todos os registros tenham o mesmo formato, é mais fácil com cut, sede grep:

cut -d' ' -f1,2,15-17 file | sed 's/*//g' | grep -P "took [[:digit:]]{3,} ms"

2020-03-11 06:19:29.857 took 100 ms
2020-03-11 06:19:29.857 took 110 ms
2020-03-11 06:19:29.857 took 400 ms

Responder2

Você pode fazer isso awkusando desta forma:

awk -F '**' '{print $2}' input_file

PARA adicionar hora e data você pode usar algo como:

awk -F '**' '{split($1,a," ");print a[1]" " a[2]" " $2}' input_file

informação relacionada