Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

13. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Marcelo Oliver
msoliver

(usa Debian)

Enviado em 18/10/2018 - 20:37h

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?



  


14. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 18/10/2018 - 22:44h

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 




15. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Marcelo Oliver
msoliver

(usa Debian)

Enviado em 19/10/2018 - 20:09h

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 



Boa noite RVMelo.
Aqui executa certinho....
Vamos descobrir o que esta errado ai....
1º - O Ubuntu 16 é bem antigo...
2º - Verifique a versão do mawk e do gawk, com o comando:
apt show mawk
Aqui tenho Version: 1.3.3-17+b3
apt show gawk
Aqui tenho: Version: 1:4.1.4+dfsg-1

Poste o valor das variáveis:
str e FNR, as mesmas devem ser:
str: "laranja" (no caso do exemplo, sem aspas)
FNR: "FNR==1||FNR==4" (no caso do exemplo, sem aspas)

Poste o Arquivo que você esta usando.... O equivalente ao do nome das frutas...
O ERRO ocorre pq não esta pegando as variáveis corretamente....
Normalmente a causa é o formato "DOS"...

Verifique se o "arquivo das frutas", está no formato linux!
cat -A ARQ1_dos #FORMATO DOS, termina com ^M$
laranja^M$
limM-CM-#o^M$
maM-CM-'M-CM-#^M$
laranja^M$
abacaxi^M$
user@debian:~$ cat -A ARQ1 #FORMATO LINUX, termina com $
laranja$
limM-CM-#o$
maM-CM-'M-CM-#$
laranja$
abacaxi$

Se esse for o problema, pode resolver facilmente com o sed
sed -i 's/^M$//' ARQUIVO #muda para linux! Ctrl v e Ctrl m para escrever ^M
Att.:
Marcelo Oliver




16. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 20/10/2018 - 11:12h

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 



Boa noite RVMelo.
Aqui executa certinho....
Vamos descobrir o que esta errado ai....
1º - O Ubuntu 16 é bem antigo...
2º - Verifique a versão do mawk e do gawk, com o comando:
apt show mawk
Aqui tenho Version: 1.3.3-17+b3
apt show gawk
Aqui tenho: Version: 1:4.1.4+dfsg-1

Poste o valor das variáveis:
str e FNR, as mesmas devem ser:
str: "laranja" (no caso do exemplo, sem aspas)
FNR: "FNR==1||FNR==4" (no caso do exemplo, sem aspas)

Poste o Arquivo que você esta usando.... O equivalente ao do nome das frutas...
O ERRO ocorre pq não esta pegando as variáveis corretamente....
Normalmente a causa é o formato "DOS"...

Verifique se o "arquivo das frutas", está no formato linux!
cat -A ARQ1_dos #FORMATO DOS, termina com ^M$
laranja^M$
limM-CM-#o^M$
maM-CM-'M-CM-#^M$
laranja^M$
abacaxi^M$
user@debian:~$ cat -A ARQ1 #FORMATO LINUX, termina com $
laranja$
limM-CM-#o$
maM-CM-'M-CM-#$
laranja$
abacaxi$

Se esse for o problema, pode resolver facilmente com o sed
sed -i 's/^M$//' ARQUIVO #muda para linux! Ctrl v e Ctrl m para escrever ^M
Att.:
Marcelo Oliver



versão mawk: 1.3.3-17ubuntu2
versão gawk: 1:4.1.3+dfsg-0.1

De acordo com o meu exemplo a variável str retorna: I love you

FNR não retorna nada.

Arquivo 1:

I love you
jessyka
I love you
kate


Arquivo 2:

ID: 1
ID: 2
ID: 3
ID: 4


O comando cat -A ARQ1 me retorna:

I love you$
jessyka$
I love you$
kate$
$







17. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 20/10/2018 - 14:13h

msoliver escreveu:

Boa tarde.
Peguei o erro....
Devido aos espaços na variável 'str', e necessário uma pequena alteração, segue:
FNR=$(awk '/'"${str}"'/ {printf "FNR==%s||" ,NR}' ARQ1|sed 's/||$//')
Obs.: aspas simples / aspas simples aspas duplas ${str} aspas duplas aspas simples /

Se a RESPOSTA foi Satisfatória e sanou suas duvidas, marque o tópico como RESOLVIDO e a MiNHA resposta como a MELHOR....
Assim ganho uns pontinhos . . . Rsrsrsr

Att.:
Marcelo Oliver


Agora funcionou obrigado!!




18. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 22/10/2018 - 01:46h

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 



Boa noite RVMelo.
Aqui executa certinho....
Vamos descobrir o que esta errado ai....
1º - O Ubuntu 16 é bem antigo...
2º - Verifique a versão do mawk e do gawk, com o comando:
apt show mawk
Aqui tenho Version: 1.3.3-17+b3
apt show gawk
Aqui tenho: Version: 1:4.1.4+dfsg-1

Poste o valor das variáveis:
str e FNR, as mesmas devem ser:
str: "laranja" (no caso do exemplo, sem aspas)
FNR: "FNR==1||FNR==4" (no caso do exemplo, sem aspas)

Poste o Arquivo que você esta usando.... O equivalente ao do nome das frutas...
O ERRO ocorre pq não esta pegando as variáveis corretamente....
Normalmente a causa é o formato "DOS"...

Verifique se o "arquivo das frutas", está no formato linux!
cat -A ARQ1_dos #FORMATO DOS, termina com ^M$
laranja^M$
limM-CM-#o^M$
maM-CM-'M-CM-#^M$
laranja^M$
abacaxi^M$
user@debian:~$ cat -A ARQ1 #FORMATO LINUX, termina com $
laranja$
limM-CM-#o$
maM-CM-'M-CM-#$
laranja$
abacaxi$

Se esse for o problema, pode resolver facilmente com o sed
sed -i 's/^M$//' ARQUIVO #muda para linux! Ctrl v e Ctrl m para escrever ^M
Att.:
Marcelo Oliver



Boa noite! funcionou com aquele exemplo no entanto quando tento com esses arquivos:

ARQ1:

0.204849,22,0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.000000,8,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.998785,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,3,2,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal


ARQ2:

1531934504.408911 177.207.38.13 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33


Eu obtenho esse erro:

.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:475: 9.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error


No entanto ele apenas ocorre com um número alto de linhas... tipo 10.000.... preciso de uma força aqui.....



19. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Marcelo Oliver
msoliver

(usa Debian)

Enviado em 22/10/2018 - 20:28h

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 



Boa noite RVMelo.
Aqui executa certinho....
Vamos descobrir o que esta errado ai....
1º - O Ubuntu 16 é bem antigo...
2º - Verifique a versão do mawk e do gawk, com o comando:
apt show mawk
Aqui tenho Version: 1.3.3-17+b3
apt show gawk
Aqui tenho: Version: 1:4.1.4+dfsg-1

Poste o valor das variáveis:
str e FNR, as mesmas devem ser:
str: "laranja" (no caso do exemplo, sem aspas)
FNR: "FNR==1||FNR==4" (no caso do exemplo, sem aspas)

Poste o Arquivo que você esta usando.... O equivalente ao do nome das frutas...
O ERRO ocorre pq não esta pegando as variáveis corretamente....
Normalmente a causa é o formato "DOS"...

Verifique se o "arquivo das frutas", está no formato linux!
cat -A ARQ1_dos #FORMATO DOS, termina com ^M$
laranja^M$
limM-CM-#o^M$
maM-CM-'M-CM-#^M$
laranja^M$
abacaxi^M$
user@debian:~$ cat -A ARQ1 #FORMATO LINUX, termina com $
laranja$
limM-CM-#o$
maM-CM-'M-CM-#$
laranja$
abacaxi$

Se esse for o problema, pode resolver facilmente com o sed
sed -i 's/^M$//' ARQUIVO #muda para linux! Ctrl v e Ctrl m para escrever ^M
Att.:
Marcelo Oliver



Boa noite! funcionou com aquele exemplo no entanto quando tento com esses arquivos:

ARQ1:

0.204849,22,0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.000000,8,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.998785,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,3,2,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal


ARQ2:

1531934504.408911 177.207.38.13 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33


Eu obtenho esse erro:

.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:475: 9.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error


No entanto ele apenas ocorre com um número alto de linhas... tipo 10.000.... preciso de uma força aqui.....


Mais uma vez, aqui funcionou....
com o ARQ1 e ARQ2 que voce postou...
Verifique o valor da var "str".



20. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 23/10/2018 - 12:43h

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

rvmelo escreveu:

msoliver escreveu:

Boa tarde.
Qual distribuição vc utiliza?
Qual o comando para chamar o script?


Boa noite. Utilizando o comando uname -a esse é o retorno:

Linux server-VirtualBox 4.4.0-104-generic #127-Ubuntu SMP Mon Dec 11 12:16:42 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux 


Já com lsb_release -a o retorno é esse:

No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial


Utilizo linux no virtualbox

Ok, observei que é no virtualbox.
Faltou responder a pergunta:
Qual o comando dado no terminal para chamar o script?


Esse é o comando:

./rm_duplicate_patterns.sh 



Boa noite RVMelo.
Aqui executa certinho....
Vamos descobrir o que esta errado ai....
1º - O Ubuntu 16 é bem antigo...
2º - Verifique a versão do mawk e do gawk, com o comando:
apt show mawk
Aqui tenho Version: 1.3.3-17+b3
apt show gawk
Aqui tenho: Version: 1:4.1.4+dfsg-1

Poste o valor das variáveis:
str e FNR, as mesmas devem ser:
str: "laranja" (no caso do exemplo, sem aspas)
FNR: "FNR==1||FNR==4" (no caso do exemplo, sem aspas)

Poste o Arquivo que você esta usando.... O equivalente ao do nome das frutas...
O ERRO ocorre pq não esta pegando as variáveis corretamente....
Normalmente a causa é o formato "DOS"...

Verifique se o "arquivo das frutas", está no formato linux!
cat -A ARQ1_dos #FORMATO DOS, termina com ^M$
laranja^M$
limM-CM-#o^M$
maM-CM-'M-CM-#^M$
laranja^M$
abacaxi^M$
user@debian:~$ cat -A ARQ1 #FORMATO LINUX, termina com $
laranja$
limM-CM-#o$
maM-CM-'M-CM-#$
laranja$
abacaxi$

Se esse for o problema, pode resolver facilmente com o sed
sed -i 's/^M$//' ARQUIVO #muda para linux! Ctrl v e Ctrl m para escrever ^M
Att.:
Marcelo Oliver



Boa noite! funcionou com aquele exemplo no entanto quando tento com esses arquivos:

ARQ1:

0.204849,22,0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.000000,8,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal
0.998785,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,3,2,normal
1.000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal


ARQ2:

1531934504.408911 177.207.38.13 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33
1531934510.831686 172.31.17.74 172.31.18.33


Eu obtenho esse erro:

.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:475: 9.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal
awk: lin. de com.:475: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:476: 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal/ {printf "FNR==%s||" ,NR}
awk: lin. de com.:476: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error
awk: lin. de com.:1: {if () ;else print $0}
awk: lin. de com.:1: ^ syntax error


No entanto ele apenas ocorre com um número alto de linhas... tipo 10.000.... preciso de uma força aqui.....


Mais uma vez, aqui funcionou....
com o ARQ1 e ARQ2 que voce postou...
Verifique o valor da var "str".


Bom dia! Esse é o valor da variável str:

0.000000,123,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.000000,3,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18,18,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30,30,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,6,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,10,10,16,16,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,10,10,28,28,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,10,10,40,40,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,2,2,20,20,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,2,2,2,2,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,2,2,32,32,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,2,2,8,8,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,4,4,10,10,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,4,4,22,22,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,4,4,34,34,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,4,4,4,4,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,6,6,12,12,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,6,6,24,24,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,6,6,36,36,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,8,8,14,14,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,8,8,26,26,normal 0.000000,53,5,0,0,0,0,0,0,0,0,0,0,0,0,8,8,38,38,normal 0.000000,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,normal 0.000000,80,5,0,0,0,0,0,0,0,0,0,0,0,0,160,159,100,100,anomaly 0.000000,80,5,0,0,0,0,0,0,0,0,0,0,0,0,180,179,100,100,anomaly 0.000000,80,5,0,0,0,0,0,0,0,0,0,0,0,0,181,180,100,100,anomaly 0.000000,80,5,0,0,0,0,0,0,0,0,0,0,0,0,182,181,100,100,anomaly 0.000000,8,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,normal 0.000000,8,10,0,0,0,0,0,0,0,0,0,0,0,0,1,0,17,14,normal 0.000013,88,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,91,0,normal 0.000017,445,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,3,normal 0.000018,445,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,0,normal 0.000018,445,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,99,4,normal 0.000018,445,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,12,1,normal 0.000018,445,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,99,5,normal 0.000019,445,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9,0,normal 0.000019,445,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,100,1,normal 0.000019,445,1,0,0,0,0,0,0,0,0,0,0,0,0,2,2,15,2,normal 0.000019,80,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.000019,80,6,0,0,0,0,0,0,0,0,0,0,0,0,1,1,36,25,normal 0.000020,23,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,0,normal 0.000020,445,1,0,0,0,0,0,0,0,0,0,0,0,0,1,1,14,1,normal 0.000020,445,1,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,2,normal 0.000020,81,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,17,1,normal 0.000021,23,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28,0,normal 0.000021,8,9,0,56,0,0,0,0,0,0,0,0,0,0,2,1,18,15,normal 0.000027,34567,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21,0,normal 0.000028,8,9,0,56,0,0,0,0,0,0,0,0,0,0,1,1,2,1,normal 0.000030,445,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,13,0,normal 0.000037,81,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,23,0,normal 0.000229,53,9,0,121,0,0,0,0,0,0,0,0,0,0,11,11,17,17,normal 0.000241,53,9,0,76,0,0,0,0,0,0,0,0,0,0,9,9,27,27,normal 0.000263,53,9,0,76,0,0,0,0,0,0,0,0,0,0,9,9,15,15,normal 0.000268,53,9,0,121,0,0,0,0,0,0,0,0,0,0,11,11,41,41,normal 0.000274,53,9,0,76,0,0,0,0,0,0,0,0,0,0,9,9,39,39,normal 0.000275,53,9,0,121,0,0,0,0,0,0,0,0,0,0,7,7,25,25,normal 0.000282,53,9,0,121,0,0,0,0,0,0,0,0,0,0,11,11,29,29,normal 0.000334,53,9,0,121,0,0,0,0,0,0,0,0,0,0,7,7,13,13,normal 0.000381,53,9,0,121,0,0,0,0,0,0,0,0,0,0,7,7,37,37,normal 0.001209,53,9,0,76,0,0,0,0,0,0,0,0,0,0,3,3,9,9,normal 0.001348,53,9,0,99,0,0,0,0,0,0,0,0,0,0,3,3,3,3,normal 0.001393,53,9,0,76,0,0,0,0,0,0,0,0,0,0,3,3,21,21,normal 0.001395,80,2,0,0,0,0,0,0,0,0,0,0,0,0,2,2,98,96,anomaly 0.001455,53,9,0,76,0,0,0,0,0,0,0,0,0,0,3,3,33,33,normal 0.001728,53,9,0,80,0,0,0,0,0,0,0,0,0,0,1,1,1,1,normal 0.001819,53,9,0,121,0,0,0,0,0,0,0,0,0,0,1,1,7,7,normal 0.023679,53,9,0,121,0,0,0,0,0,0,0,0,0,0,1,1,31,31,normal 0.025452,53,9,0,121,0,0,0,0,0,0,0,0,0,0,5,5,11,11,normal 0.028498,53,9,0,121,0,0,0,0,0,0,0,0,0,0,5,5,35,35,normal 0.032969,53,9,0,121,0,0,0,0,0,0,0,0,0,0,5,5,23,23,normal 0.037300,53,9,0,121,0,0,0,0,0,0,0,0,0,0,1,1,19,19,normal 0.086294,53,9,0,67,0,0,0,0,0,0,0,0,0,0,5,5,5,5,normal 0.167919,80,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22,15,normal 0.178835,19743,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30,0,normal 0.184017,4027,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11,0,normal 0.195076,22,0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.198029,7744,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,normal 0.201496,56084,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32,0,normal 0.204849,22,0,0,188,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 0.205635,3777,1,0,0,0,0,0,0,0,0,0,0,0,0,2,0,20,0,normal 0.211002,5544,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,99,0,normal 0.251278,15787,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,100,0,normal 0.272144,17777,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21,0,normal 0.304741,22,9,1,60,0,0,0,0,0,0,0,0,0,0,0,0,99,0,normal 0.306433,55644,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,100,0,normal 0.311947,15596,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,normal 0.539724,80,6,3499,3573,0,0,0,0,0,0,0,0,0,0,0,0,40,54,normal 0.842013,80,6,7477,3469,0,0,0,0,0,0,0,0,0,0,0,0,35,24,normal 0.998785,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,3,2,normal 0.998804,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,4,3,normal 0.998955,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,21,18,normal 0.998974,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,22,19,normal 10.082869,80,9,3701,7080,0,0,0,0,0,0,0,0,0,0,0,0,35,53,normal 100.840347,8,9,0,0,0,0,0,0,0,0,0,0,0,0,16,16,99,90,normal 100.840366,8,9,0,56,0,0,0,0,0,0,0,0,0,0,17,17,99,90,normal 101.840598,8,9,0,0,0,0,0,0,0,0,0,0,0,0,18,18,99,90,normal 101.840617,8,9,0,56,0,0,0,0,0,0,0,0,0,0,19,19,99,90,normal 102.840413,8,9,0,0,0,0,0,0,0,0,0,0,0,0,20,20,99,90,normal 102.840434,8,9,0,56,0,0,0,0,0,0,0,0,0,0,21,21,99,90,normal 103.840407,8,9,0,0,0,0,0,0,0,0,0,0,0,0,22,22,99,90,normal 103.840426,8,9,0,56,0,0,0,0,0,0,0,0,0,0,23,23,99,90,normal 104.840469,8,9,0,0,0,0,0,0,0,0,0,0,0,0,24,24,99,90,normal 104.840489,8,9,0,56,0,0,0,0,0,0,0,0,0,0,25,25,99,90,normal 105.840455,8,9,0,0,0,0,0,0,0,0,0,0,0,0,26,26,99,90,normal 105.840475,8,9,0,56,0,0,0,0,0,0,0,0,0,0,27,27,99,90,normal 106.840494,8,9,0,0,0,0,0,0,0,0,0,0,0,0,28,28,99,90,normal 106.840525,8,9,0,56,0,0,0,0,0,0,0,0,0,0,29,29,99,90,normal 10.745553,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,49,46,normal 10.745560,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,50,47,normal 107.840535,8,9,0,0,0,0,0,0,0,0,0,0,0,0,30,30,99,90,normal 107.840563,8,9,0,56,0,0,0,0,0,0,0,0,0,0,31,31,99,90,normal 108.840559,8,9,0,0,0,0,0,0,0,0,0,0,0,0,32,32,99,90,normal 108.840577,8,9,0,56,0,0,0,0,0,0,0,0,0,0,33,33,99,90,normal 1.091639,22,0,36,188,0,0,0,0,0,0,0,0,0,0,0,0,0,2,normal 109.840559,8,9,0,0,0,0,0,0,0,0,0,0,0,0,34,34,99,90,normal 109.840578,8,9,0,56,0,0,0,0,0,0,0,0,0,0,35,35,99,90,normal 10.997436,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,35,32,normal 10.997456,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,36,33,normal 110.840554,8,9,0,0,0,0,0,0,0,0,0,0,0,0,36,36,99,90,normal 110.840574,8,9,0,56,0,0,0,0,0,0,0,0,0,0,37,37,99,90,normal 111.840663,8,9,0,0,0,0,0,0,0,0,0,0,0,0,38,38,99,90,normal 111.840682,8,9,0,56,0,0,0,0,0,0,0,0,0,0,39,39,99,90,normal 112.840644,8,9,0,0,0,0,0,0,0,0,0,0,0,0,40,40,99,90,normal 112.840664,8,9,0,56,0,0,0,0,0,0,0,0,0,0,41,41,99,90,normal 11.285256,80,9,3495,4179,0,0,0,0,0,0,0,0,0,0,0,0,12,35,normal 113.840612,8,9,0,0,0,0,0,0,0,0,0,0,0,0,42,42,99,90,normal 113.840629,8,9,0,56,0,0,0,0,0,0,0,0,0,0,43,43,99,90,normal 114.840661,8,9,0,0,0,0,0,0,0,0,0,0,0,0,44,44,99,90,normal 114.840681,8,9,0,56,0,0,0,0,0,0,0,0,0,0,45,45,99,90,normal 115.840670,8,9,0,0,0,0,0,0,0,0,0,0,0,0,46,46,99,90,normal 115.840688,8,9,0,56,0,0,0,0,0,0,0,0,0,0,47,47,99,91,normal 116.840728,8,9,0,0,0,0,0,0,0,0,0,0,0,0,48,48,99,92,normal 116.840747,8,9,0,56,0,0,0,0,0,0,0,0,0,0,49,49,99,93,normal 11.744056,80,9,7708,28898,0,0,0,0,0,0,0,0,0,0,0,0,29,21,normal 11.744640,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,53,50,normal 11.744651,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,54,51,normal 117.840819,8,9,0,0,0,0,0,0,0,0,0,0,0,0,50,50,99,93,normal 117.840844,8,9,0,56,0,0,0,0,0,0,0,0,0,0,51,51,99,93,normal 11.838836,80,9,1905,9009,0,0,0,0,0,0,0,0,0,0,0,0,34,53,normal 118.840779,8,9,0,0,0,0,0,0,0,0,0,0,0,0,52,52,99,94,normal 118.840798,8,9,0,56,0,0,0,0,0,0,0,0,0,0,53,53,99,94,normal 119.840810,8,9,0,0,0,0,0,0,0,0,0,0,0,0,54,54,99,94,normal 119.840830,8,9,0,56,0,0,0,0,0,0,0,0,0,0,55,55,99,95,normal 11.997445,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,37,34,normal 11.997465,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,38,35,normal 12.006257,80,9,1249,1413,0,0,0,0,0,0,0,0,0,0,0,0,26,18,normal 120.840851,8,9,0,0,0,0,0,0,0,0,0,0,0,0,56,56,99,95,normal 120.840877,8,9,0,56,0,0,0,0,0,0,0,0,0,0,57,57,99,95,normal 121.840896,8,9,0,0,0,0,0,0,0,0,0,0,0,0,58,58,99,94,normal 121.840916,8,9,0,56,0,0,0,0,0,0,0,0,0,0,59,59,99,95,normal 12.244022,80,9,4678,9184,0,0,0,0,0,0,0,0,0,0,0,0,8,32,normal 122.840896,8,9,0,0,0,0,0,0,0,0,0,0,0,0,60,60,99,95,normal 122.840917,8,9,0,56,0,0,0,0,0,0,0,0,0,0,61,61,99,95,normal 123.840896,8,9,0,0,0,0,0,0,0,0,0,0,0,0,62,62,99,95,normal 123.840915,8,9,0,56,0,0,0,0,0,0,0,0,0,0,63,63,99,95,normal 12.452865,80,9,641,3418,0,0,0,0,0,0,0,0,0,0,0,0,36,54,normal 124.840933,8,9,0,0,0,0,0,0,0,0,0,0,0,0,64,64,99,95,normal 124.840952,8,9,0,56,0,0,0,0,0,0,0,0,0,0,65,65,99,95,normal 125.840927,8,9,0,0,0,0,0,0,0,0,0,0,0,0,66,66,99,95,normal 125.840948,8,9,0,56,0,0,0,0,0,0,0,0,0,0,67,67,99,95,normal 12.599310,80,9,0,0,0,0,0,0,0,0,0,0,0,0,1,1,39,54,normal 126.840958,8,9,0,0,0,0,0,0,0,0,0,0,0,0,68,68,99,95,normal 126.840978,8,9,0,56,0,0,0,0,0,0,0,0,0,0,69,69,99,95,normal 12.769523,80,9,0,0,0,0,0,0,0,0,0,0,0,0,1,1,20,42,normal 12.770225,80,9,1314,6229,0,0,0,0,0,0,0,0,0,0,0,0,38,54,normal 127.840970,8,9,0,0,0,0,0,0,0,0,0,0,0,0,70,70,100,96,normal 127.840988,8,9,0,56,0,0,0,0,0,0,0,0,0,0,71,71,100,96,normal 128.841041,8,9,0,0,0,0,0,0,0,0,0,0,0,0,72,72,100,96,normal 128.841061,8,9,0,56,0,0,0,0,0,0,0,0,0,0,73,73,100,96,normal 12.961292,80,9,1956,7571,0,0,0,0,0,0,0,0,0,0,0,0,19,41,normal 129.841049,8,9,0,0,0,0,0,0,0,0,0,0,0,0,74,74,100,96,normal 129.841069,8,9,0,56,0,0,0,0,0,0,0,0,0,0,75,75,100,97,normal 12.997476,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,39,36,normal 12.997495,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,40,37,normal 130.841037,8,9,0,0,0,0,0,0,0,0,0,0,0,0,76,76,100,97,normal 130.841057,8,9,0,56,0,0,0,0,0,0,0,0,0,0,77,77,100,97,normal 131.841150,8,9,0,0,0,0,0,0,0,0,0,0,0,0,78,78,100,97,normal 131.841170,8,9,0,56,0,0,0,0,0,0,0,0,0,0,79,79,100,97,normal 132.841175,8,9,0,0,0,0,0,0,0,0,0,0,0,0,80,80,100,97,normal 132.841194,8,9,0,56,0,0,0,0,0,0,0,0,0,0,81,81,100,97,normal 13.363459,80,9,6699,21064,0,0,0,0,0,0,0,0,0,0,1,1,25,17,normal 133.841214,8,9,0,0,0,0,0,0,0,0,0,0,0,0,82,82,100,97,normal 133.841245,8,9,0,56,0,0,0,0,0,0,0,0,0,0,83,83,100,97,normal 134.841161,8,9,0,0,0,0,0,0,0,0,0,0,0,0,84,84,100,97,normal 134.841181,8,9,0,56,0,0,0,0,0,0,0,0,0,0,85,85,100,97,normal 135.841164,8,9,0,0,0,0,0,0,0,0,0,0,0,0,86,86,100,97,normal 135.841183,8,9,0,56,0,0,0,0,0,0,0,0,0,0,87,87,100,97,normal 136.841199,8,9,0,0,0,0,0,0,0,0,0,0,0,0,88,88,100,97,normal 136.841218,8,9,0,56,0,0,0,0,0,0,0,0,0,0,89,89,100,97,normal 137.841229,8,9,0,0,0,0,0,0,0,0,0,0,0,0,90,90,100,97,normal 137.841248,8,9,0,56,0,0,0,0,0,0,0,0,0,0,91,91,100,97,normal 13.840195,80,9,2142,7870,0,0,0,0,0,0,0,0,0,0,1,0,24,16,normal 138.841293,8,9,0,0,0,0,0,0,0,0,0,0,0,0,92,92,100,97,normal 138.841313,8,9,0,56,0,0,0,0,0,0,0,0,0,0,93,93,100,97,normal 139.841302,8,9,0,0,0,0,0,0,0,0,0,0,0,0,94,94,100,97,normal 139.841322,8,9,0,56,0,0,0,0,0,0,0,0,0,0,95,95,100,97,normal 13.997551,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,41,38,normal 13.997571,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,42,39,normal 140.841288,8,9,0,0,0,0,0,0,0,0,0,0,0,0,96,96,100,97,normal 140.841307,8,9,0,56,0,0,0,0,0,0,0,0,0,0,97,97,100,97,normal 14.181160,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,59,56,normal 14.181179,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,60,57,normal 141.841317,8,9,0,0,0,0,0,0,0,0,0,0,0,0,98,98,100,98,normal 141.841337,8,9,0,56,0,0,0,0,0,0,0,0,0,0,99,99,100,99,normal 142.841330,8,9,0,0,0,0,0,0,0,0,0,0,0,0,100,100,100,99,normal 142.841349,8,9,0,56,0,0,0,0,0,0,0,0,0,0,101,101,100,99,normal 14.555940,80,9,5426,20212,0,0,0,0,0,0,0,0,0,0,0,0,10,8,normal 14.600653,80,9,2215,41287,0,0,0,0,0,0,0,0,0,0,1,0,34,23,normal 14.686880,80,9,2283,14150,0,0,0,0,0,0,0,0,0,0,0,0,12,10,normal 14.827836,80,9,634,3247,0,0,0,0,0,0,0,0,0,0,0,0,27,48,normal 14.970177,80,9,4733,9072,0,0,0,0,0,0,0,0,0,0,0,0,23,44,normal 14.988913,80,9,1375,3574,0,0,0,0,0,0,0,0,0,0,0,0,9,7,normal 14.997520,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,43,40,normal 14.997539,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,44,41,normal 15.180205,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,63,60,normal 15.180224,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,64,61,normal 15.444761,80,9,0,0,0,0,0,0,0,0,0,0,0,0,3,3,5,29,normal 15.445149,80,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,6,30,normal 15.463334,80,9,0,0,0,0,0,0,0,0,0,0,0,0,1,1,3,27,normal 15.464242,80,9,0,0,0,0,0,0,0,0,0,0,0,0,1,1,15,38,normal 15.997608,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,45,42,normal 15.997627,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,46,43,normal 16.193324,80,9,4449,15360,0,0,0,0,0,0,0,0,0,0,0,0,14,37,normal 16.997570,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,47,44,normal 16.997588,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,48,45,normal 16.997818,80,9,673,2726,0,0,0,0,0,0,0,0,0,0,0,0,10,34,normal 17.826318,80,9,4338,13035,0,0,0,0,0,0,0,0,0,0,1,1,32,52,normal 17.997625,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,51,48,normal 17.997644,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,52,49,normal 1.801963,22,9,1123,1969,0,0,0,0,0,0,0,0,0,0,1,0,33,1,normal 18.311128,80,9,3102,13400,0,0,0,0,0,0,0,0,0,0,1,1,19,14,normal 18.716811,80,9,3375,10549,0,0,0,0,0,0,0,0,0,0,0,0,8,6,normal 18.997819,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,55,52,normal 18.997838,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,56,53,normal 1.915703,25,2,1024,697,0,0,0,0,0,0,0,0,0,0,0,0,0,0,normal 1.997866,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,5,4,normal 1.997887,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,6,5,normal 1.997990,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,25,22,normal 1.998009,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,26,23,normal 19.997608,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,57,54,normal 19.997628,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,58,55,normal 20.997687,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,61,58,normal 20.997705,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,62,59,normal 21.398979,80,9,3434,11273,0,0,0,0,0,0,0,0,0,0,1,1,17,12,normal 21.843542,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,79,76,normal 21.843560,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,80,77,normal 21.848930,80,9,7566,23285,0,0,0,0,0,0,0,0,0,0,1,1,28,20,normal 21.997686,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,65,62,normal 21.997706,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,66,63,normal 22.106075,80,9,8393,29482,0,0,0,0,0,0,0,0,0,0,0,0,16,11,normal 22.842617,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,83,80,normal 22.842638,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,84,81,normal 22.997679,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,67,64,normal 22.997697,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,68,65,normal 23.842493,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,87,84,normal 23.842513,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,88,85,normal 23.997698,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,69,66,normal 23.997718,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,70,67,normal 24.842475,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,92,88,normal 24.842495,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,93,89,normal 24.884006,80,9,1884,7659,0,0,0,0,0,0,0,0,0,0,0,0,7,31,normal 24.997734,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,71,68,normal 24.997754,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,72,69,normal 25.694304,80,9,8878,24473,0,0,0,0,0,0,0,0,0,0,0,0,18,40,normal 25.997728,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,73,70,normal 25.997754,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,74,71,normal 26.997775,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,75,72,normal 26.997794,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,76,73,normal 27.285429,80,9,675,2389,0,0,0,0,0,0,0,0,0,0,0,0,26,47,normal 27.997763,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,77,74,normal 27.997781,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,78,75,normal 28.277082,80,9,2225,41283,0,0,0,0,0,0,0,0,0,0,0,0,2,1,normal 28.997849,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,81,78,normal 28.997874,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,82,79,normal 29.041949,80,9,671,2807,0,0,0,0,0,0,0,0,0,0,0,0,16,39,normal 29.610746,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,97,normal 29.610766,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,97,normal 2.997275,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,7,6,normal 2.997302,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,8,7,normal 2.998081,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,29,26,normal 2.998102,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,30,27,normal 29.997869,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,85,82,normal 29.997889,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,86,83,normal 3.035864,80,5,0,0,0,0,0,0,0,0,0,0,0,0,41,41,100,100,anomaly 3.038609,80,5,0,0,0,0,0,0,0,0,0,0,0,0,53,53,100,100,anomaly 30.610669,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,97,normal 30.610688,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,97,normal 30.997861,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,89,86,normal 30.997881,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,90,87,normal 30.998989,80,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30,50,normal 31.340041,80,9,3248,9234,0,0,0,0,0,0,0,0,0,0,2,2,4,28,normal 31.611909,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,98,normal 31.611929,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,98,normal 31.997928,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,94,90,normal 31.997948,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,95,91,normal 32.612445,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 32.612463,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 32.998031,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,96,92,normal 32.998050,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,97,93,normal 33.611528,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 33.611555,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 33.997976,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,98,94,normal 33.997995,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,99,95,normal 34.610786,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 34.610808,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 35.000025,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,100,96,normal 35.000045,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,100,97,normal 35.998911,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,100,97,normal 35.998930,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,100,97,normal 36.998024,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,97,normal 36.998042,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,97,normal 37.998027,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,98,normal 37.998046,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 38.998015,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 38.998033,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 39.171159,80,9,10345,43023,0,0,0,0,0,0,0,0,0,0,0,0,25,46,normal 3.997325,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,10,8,normal 3.997345,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,11,9,normal 3.998039,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,33,30,normal 3.998060,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,34,31,normal 39.998068,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 39.998087,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 40.998143,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,99,normal 40.998161,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,99,normal 41.998132,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,100,99,normal 41.998151,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,100,99,normal 42.998191,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,100,99,normal 42.998212,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,100,99,normal 43.998142,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,100,99,normal 43.998161,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,100,99,normal 44.998261,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,100,98,normal 44.998286,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,100,98,normal 45.998186,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,100,98,normal 45.998205,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,100,98,normal 46.998199,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,100,98,normal 46.998218,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,100,98,normal 47.998299,8,9,0,0,0,0,0,0,0,0,0,0,0,0,16,16,100,98,normal 47.998317,8,9,0,56,0,0,0,0,0,0,0,0,0,0,17,17,100,98,normal 48.998392,8,9,0,0,0,0,0,0,0,0,0,0,0,0,18,18,100,98,normal 48.998423,8,9,0,56,0,0,0,0,0,0,0,0,0,0,19,19,100,98,normal 4.997282,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,13,10,normal 4.997302,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,14,11,normal 49.998310,8,9,0,0,0,0,0,0,0,0,0,0,0,0,20,20,100,98,normal 49.998329,8,9,0,56,0,0,0,0,0,0,0,0,0,0,21,21,100,98,normal 50.998427,8,9,0,0,0,0,0,0,0,0,0,0,0,0,22,22,100,98,normal 50.998454,8,9,0,56,0,0,0,0,0,0,0,0,0,0,23,23,100,98,normal 51.998408,8,9,0,0,0,0,0,0,0,0,0,0,0,0,24,24,100,98,normal 51.998427,8,9,0,56,0,0,0,0,0,0,0,0,0,0,25,25,100,98,normal 52.840662,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,98,normal 52.840683,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,98,normal 52.998536,8,9,0,0,0,0,0,0,0,0,0,0,0,0,26,26,100,98,normal 52.998556,8,9,0,56,0,0,0,0,0,0,0,0,0,0,27,27,100,98,normal 53.839677,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,100,98,normal 53.839697,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,100,98,normal 53.998460,8,9,0,0,0,0,0,0,0,0,0,0,0,0,28,28,100,98,normal 53.998479,8,9,0,56,0,0,0,0,0,0,0,0,0,0,29,29,100,98,normal 5.415044,80,9,1213,3145,0,0,0,0,0,0,0,0,0,0,0,0,33,53,normal 54.839226,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,100,98,normal 54.839245,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,100,98,normal 55.839230,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,100,98,normal 55.839249,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,100,98,normal 5.633535,80,9,1152,2760,0,0,0,0,0,0,0,0,0,0,3,3,7,5,normal 56.839280,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,100,98,normal 56.839300,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,100,98,normal 57.839293,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,100,98,normal 57.839313,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,100,98,normal 58.839350,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,100,98,normal 58.839369,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,100,98,normal 5.909673,80,9,3436,12544,0,0,0,0,0,0,0,0,0,0,1,1,5,3,normal 5.945870,80,9,4719,8820,0,0,0,0,0,0,0,0,0,0,2,2,6,4,normal 5.960424,80,9,1956,4866,0,0,0,0,0,0,0,0,0,0,0,0,31,51,normal 59.839341,8,9,0,0,0,0,0,0,0,0,0,0,0,0,16,16,100,98,normal 59.839360,8,9,0,56,0,0,0,0,0,0,0,0,0,0,17,17,100,98,normal 5.997288,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,15,12,normal 5.997308,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,16,13,normal 60.839322,8,9,0,0,0,0,0,0,0,0,0,0,0,0,18,18,100,98,normal 60.839342,8,9,0,56,0,0,0,0,0,0,0,0,0,0,19,19,100,98,normal 61.839413,8,9,0,0,0,0,0,0,0,0,0,0,0,0,20,20,100,98,normal 61.839432,8,9,0,56,0,0,0,0,0,0,0,0,0,0,21,21,100,98,normal 62.839414,8,9,0,0,0,0,0,0,0,0,0,0,0,0,22,22,100,98,normal 62.839435,8,9,0,56,0,0,0,0,0,0,0,0,0,0,23,23,100,98,normal 6.295540,80,9,2122,9517,0,0,0,0,0,0,0,0,0,0,0,0,18,13,normal 63.839443,8,9,0,0,0,0,0,0,0,0,0,0,0,0,24,24,100,98,normal 63.839463,8,9,0,56,0,0,0,0,0,0,0,0,0,0,25,25,100,98,normal 64.839440,8,9,0,0,0,0,0,0,0,0,0,0,0,0,26,26,100,98,normal 64.839460,8,9,0,56,0,0,0,0,0,0,0,0,0,0,27,27,100,98,normal 6.579578,80,9,9613,13893,0,0,0,0,0,0,0,0,0,0,0,0,4,2,normal 65.839484,8,9,0,0,0,0,0,0,0,0,0,0,0,0,28,28,100,98,normal 65.839502,8,9,0,56,0,0,0,0,0,0,0,0,0,0,29,29,100,98,normal 66.839533,8,9,0,0,0,0,0,0,0,0,0,0,0,0,30,30,100,98,normal 66.839553,8,9,0,56,0,0,0,0,0,0,0,0,0,0,31,31,100,98,normal 67.839583,8,9,0,0,0,0,0,0,0,0,0,0,0,0,32,32,100,98,normal 67.839610,8,9,0,56,0,0,0,0,0,0,0,0,0,0,33,33,100,98,normal 68.839583,8,9,0,0,0,0,0,0,0,0,0,0,0,0,34,34,100,98,normal 68.839602,8,9,0,56,0,0,0,0,0,0,0,0,0,0,35,35,100,98,normal 69.839601,8,9,0,0,0,0,0,0,0,0,0,0,0,0,36,36,100,98,normal 69.839620,8,9,0,56,0,0,0,0,0,0,0,0,0,0,37,37,100,98,normal 6.997338,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,19,16,normal 6.997357,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,20,17,normal 70.839590,8,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,96,normal 70.839609,8,9,0,56,0,0,0,0,0,0,0,0,0,0,1,1,100,96,normal 7.091303,80,9,3413,3969,0,0,0,0,0,0,0,0,0,0,0,0,24,45,normal 71.839685,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,95,normal 71.839710,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,95,normal 72.839645,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,100,94,normal 72.839663,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,100,94,normal 73.839719,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,100,94,normal 73.839742,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,100,94,normal 74.839721,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,100,93,normal 74.839740,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,100,93,normal 75.839759,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,100,93,normal 75.839779,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,100,93,normal 76.839749,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,100,93,normal 76.839774,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,100,93,normal 77.839757,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,100,93,normal 77.839776,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,100,93,normal 78.839834,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,100,93,normal 78.839854,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,100,93,normal 79.839976,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,99,92,normal 79.839996,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,99,92,normal 7.997352,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,23,20,normal 7.997372,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,24,21,normal 80.839841,8,9,0,0,0,0,0,0,0,0,0,0,0,0,16,16,99,92,normal 80.839861,8,9,0,56,0,0,0,0,0,0,0,0,0,0,17,17,99,92,normal 81.839900,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,99,91,normal 81.839919,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,99,91,normal 8.282516,80,9,1152,3349,0,0,0,0,0,0,0,0,0,0,0,0,13,36,normal 82.839916,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,99,91,normal 82.839948,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,99,91,normal 83.839967,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,99,91,normal 83.839987,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,99,91,normal 84.839969,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,99,91,normal 84.839988,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,99,91,normal 85.839996,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,99,91,normal 85.840015,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,99,91,normal 86.840027,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,99,91,normal 86.840057,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,99,91,normal 87.840056,8,9,0,0,0,0,0,0,0,0,0,0,0,0,16,16,99,91,normal 87.840082,8,9,0,56,0,0,0,0,0,0,0,0,0,0,17,17,99,91,normal 8.818197,80,9,466,1938,0,0,0,0,0,0,0,0,0,0,0,0,2,26,normal 88.840071,8,9,0,0,0,0,0,0,0,0,0,0,0,0,18,18,99,92,normal 88.840090,8,9,0,56,0,0,0,0,0,0,0,0,0,0,19,19,99,92,normal 8.898253,80,9,2350,9212,0,0,0,0,0,0,0,0,0,0,0,0,31,22,normal 89.840040,8,9,0,0,0,0,0,0,0,0,0,0,0,0,20,20,99,92,normal 89.840058,8,9,0,56,0,0,0,0,0,0,0,0,0,0,21,21,99,92,normal 8.997430,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,27,24,normal 8.997449,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,28,25,normal 90.840055,8,9,0,0,0,0,0,0,0,0,0,0,0,0,22,22,99,92,normal 90.840074,8,9,0,56,0,0,0,0,0,0,0,0,0,0,23,23,99,92,normal 9.144065,80,9,1158,3349,0,0,0,0,0,0,0,0,0,0,0,0,29,49,normal 91.840126,8,9,0,0,0,0,0,0,0,0,0,0,0,0,24,24,99,92,normal 91.840145,8,9,0,56,0,0,0,0,0,0,0,0,0,0,25,25,99,92,normal 92.840163,8,9,0,0,0,0,0,0,0,0,0,0,0,0,0,0,99,90,normal 92.840182,8,9,0,56,0,0,0,0,0,0,0,0,0,0,1,1,99,90,normal 93.840171,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,99,90,normal 93.840191,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,99,90,normal 9.407909,80,9,641,3579,0,0,0,0,0,0,0,0,0,0,0,0,9,33,normal 94.841608,8,9,0,0,0,0,0,0,0,0,0,0,0,0,4,4,99,90,normal 94.841651,8,9,0,56,0,0,0,0,0,0,0,0,0,0,5,5,99,90,normal 95.842248,8,9,0,0,0,0,0,0,0,0,0,0,0,0,6,6,99,90,normal 95.842267,8,9,0,56,0,0,0,0,0,0,0,0,0,0,7,7,99,90,normal 9.610667,80,9,2289,14157,0,0,0,0,0,0,0,0,0,0,0,0,27,19,normal 96.841318,8,9,0,0,0,0,0,0,0,0,0,0,0,0,8,8,99,90,normal 96.841337,8,9,0,56,0,0,0,0,0,0,0,0,0,0,9,9,99,90,normal 97.840363,8,9,0,0,0,0,0,0,0,0,0,0,0,0,10,10,99,90,normal 97.840383,8,9,0,56,0,0,0,0,0,0,0,0,0,0,11,11,99,90,normal 9.790962,80,9,6856,6591,0,0,0,0,0,0,0,0,0,0,0,0,22,43,normal 9.806269,80,9,1283,5853,0,0,0,0,0,0,0,0,0,0,0,0,37,54,normal 9.863708,80,9,3426,12467,0,0,0,0,0,0,0,0,0,0,0,0,11,9,normal 98.840227,8,9,0,0,0,0,0,0,0,0,0,0,0,0,12,12,99,90,normal 98.840247,8,9,0,56,0,0,0,0,0,0,0,0,0,0,13,13,99,90,normal 99.840316,8,9,0,0,0,0,0,0,0,0,0,0,0,0,14,14,99,90,normal 99.840335,8,9,0,56,0,0,0,0,0,0,0,0,0,0,15,15,99,90,normal 9.997418,8,9,0,0,0,0,0,0,0,0,0,0,0,0,2,2,31,28,normal 9.997437,8,9,0,56,0,0,0,0,0,0,0,0,0,0,3,3,32,29,normal 


Por favor baixe os arquivos test.txt (corresponde a ARQ1) e alert_data.txt (Corresponde a ARQ2) desse link:

https://github.com/rvmelo/test 


Foi com esses dois arquivos que testei.



21. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 23/10/2018 - 12:47h

meu código ficou da seguinte forma:

#!/bin/bash

str=$(sort test.txt|uniq -d)
FNR=$(awk '/'"${str}"'/ {printf "FNR==%s||" ,NR}' test.txt|sed 's/||$//')
awk -i inplace '{if ('${FNR}') ;else print $0}' test.txt alert_data.txt

echo "valor de str: "
echo $str



22. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Marcelo Oliver
msoliver

(usa Debian)

Enviado em 23/10/2018 - 17:04h

Boa tarde RvMelo.
Estou verificando.
A var 'str' tem 476 linhas . . .
Estou pensando em uma solução...

EDITADO as 17:20h
Segue a solução:

#/bin/bash
C1="\e[0;38;5;226m"
C2="\e[0;38;5;2m"
C3="\e[0;38;5;39m"
str=$(sort ARQ1|uniq -d)

while read -r line;do
FNR=$(awk '/'"${line}"'/ {printf "FNR==%s||" ,NR}' ARQ1|sed 's/||$//');
awk -i inplace '{if ('${FNR}') ;else print $0}' ARQ1 ARQ2;
echo -e "\n${C1} Valor das Variáveis:\n${C2} STR: ${line} \n${C3} FNR: ${FNR}\x1B[m";
done <<< "$str"

att.:
Marcelo Oliver


23. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Roberto Vasconcelos Melo
rvmelo

(usa Outra)

Enviado em 28/10/2018 - 11:33h

msoliver escreveu:

Boa tarde RvMelo.
Estou verificando.
A var 'str' tem 476 linhas . . .
Estou pensando em uma solução...

EDITADO as 17:20h
Segue a solução:

#/bin/bash
C1="\e[0;38;5;226m"
C2="\e[0;38;5;2m"
C3="\e[0;38;5;39m"
str=$(sort ARQ1|uniq -d)

while read -r line;do
FNR=$(awk '/'"${line}"'/ {printf "FNR==%s||" ,NR}' ARQ1|sed 's/||$//');
awk -i inplace '{if ('${FNR}') ;else print $0}' ARQ1 ARQ2;
echo -e "\n${C1} Valor das Variáveis:\n${C2} STR: ${line} \n${C3} FNR: ${FNR}\x1B[m";
done <<< "$str"

att.:
Marcelo Oliver


rvmelo escreveu:

meu código ficou da seguinte forma:

#!/bin/bash

str=$(sort test.txt|uniq -d)
FNR=$(awk '/'"${str}"'/ {printf "FNR==%s||" ,NR}' test.txt|sed 's/||$//')
awk -i inplace '{if ('${FNR}') ;else print $0}' test.txt alert_data.txt

echo "valor de str: "
echo $str


Muito obrigado funcionou sim!! Mas uma pergunta só pra ter certeza... nos dois arquivos caso seja alterado a ordem das linhas em um arquivo no outro também é preciso alterar, pois são linhas correspondentes.

Por exemplo ARQ1:

ID: 1
ID: 2
ID: 3
ID: 4


ARQ2:


1,1,1,1,1,1,normal
2,2,2,2,2,2,normal
3,3,3,3,3,3,normal
4,4,4,4,4,4,anomaly


Se eu alterar ARQ2 de forma que fique assim:

4,4,4,4,4,4,anomaly
2,2,2,2,2,2,normal
3,3,3,3,3,3,normal
1,1,1,1,1,1,normal


Então ARQ1 precisa ficar assim:

ID: 4
ID: 2
ID: 3
ID: 1


E vice versa se for o oposto. Essa regra foi mantida? Obrigado!!







24. Re: Remover linhas simultaneamente em dois arquivos [RESOLVIDO]

Marcelo Oliver
msoliver

(usa Debian)

Enviado em 29/10/2018 - 19:56h

rvmelo escreveu:

msoliver escreveu:

Boa tarde RvMelo.
Estou verificando.
A var 'str' tem 476 linhas . . .
Estou pensando em uma solução...

EDITADO as 17:20h
Segue a solução:

#/bin/bash
C1="\e[0;38;5;226m"
C2="\e[0;38;5;2m"
C3="\e[0;38;5;39m"
str=$(sort ARQ1|uniq -d)

while read -r line;do
FNR=$(awk '/'"${line}"'/ {printf "FNR==%s||" ,NR}' ARQ1|sed 's/||$//');
awk -i inplace '{if ('${FNR}') ;else print $0}' ARQ1 ARQ2;
echo -e "\n${C1} Valor das Variáveis:\n${C2} STR: ${line} \n${C3} FNR: ${FNR}\x1B[m";
done <<< "$str"

att.:
Marcelo Oliver


rvmelo escreveu:

meu código ficou da seguinte forma:

#!/bin/bash

str=$(sort test.txt|uniq -d)
FNR=$(awk '/'"${str}"'/ {printf "FNR==%s||" ,NR}' test.txt|sed 's/||$//')
awk -i inplace '{if ('${FNR}') ;else print $0}' test.txt alert_data.txt

echo "valor de str: "
echo $str


Muito obrigado funcionou sim!! Mas uma pergunta só pra ter certeza... nos dois arquivos caso seja alterado a ordem das linhas em um arquivo no outro também é preciso alterar, pois são linhas correspondentes.

Por exemplo ARQ1:

ID: 1
ID: 2
ID: 3
ID: 4


ARQ2:


1,1,1,1,1,1,normal
2,2,2,2,2,2,normal
3,3,3,3,3,3,normal
4,4,4,4,4,4,anomaly


Se eu alterar ARQ2 de forma que fique assim:

4,4,4,4,4,4,anomaly
2,2,2,2,2,2,normal
3,3,3,3,3,3,normal
1,1,1,1,1,1,normal


Então ARQ1 precisa ficar assim:

ID: 4
ID: 2
ID: 3
ID: 1


E vice versa se for o oposto. Essa regra foi mantida? Obrigado!!


Boa tarde RVMelo.
O script, sequencia de comandos....
Foi feito considerando uma relação entre os dois arquivos....
Caso os arquivos não tenham essa "relação"..... não vai funcionar.
Veja bem:
O comando:
sort arquivo1|uniq -d => Ordena o arquivo e "pega" somente o conteúdo das linhas repetidas.
O comando:
awk '/'"${str}"'/ {printf "FNR==%s||" ,NR}' arquivo1|sed 's/||$//' => Pega o Número das Linhas repetidas e monta o "condicional"
Em tempo, os dois comandos acima baseiam-se somente em um dos arquivos.
Já o comando:
awk -i inplace '{if ('${FNR}') ;else print $0}' arquivo1 arquivo2 => Imprime somente as linhas de ambos arquivos que não casam com o condicional.
Conclusão:
Se a ordem das linhas não coincidirem nos arquivos, você deve "duplicar" os comandos, fazer um para cada arquivo, separadamente.
Exemplo:
str1=$(sort test.txt|uniq -d)
NR1=$(awk '/'"${str}"'/ {printf "NR==%s||" ,NR}' test.txt|sed 's/||$//')
awk -i inplace '{if ('${NR1}') ;else print $0}' test.txt

str2=$(sort alert_data.txt|uniq -d)
NR2=$(awk '/'"${str}"'/ {printf "NR==%s||" ,NR}' alert_data.txt|sed 's/||$//')
awk -i inplace '{if ('${NR2}') ;else print $0}' alert_data.txt


Obs.: Se a variável "str" tiver mais de uma linha, use a opção:
while read -r line;do
FNR=$(awk '/'"${line}"'/ {printf "FNR==%s||" ,NR}' ARQ1|sed 's/||$//');
awk -i inplace '{if ('${FNR}') ;else print $0}' ARQ1 ARQ2;
echo -e "\n${C1} Valor das Variáveis:\n${C2} STR: ${line} \n${C3} FNR: ${FNR}\x1B[m";
done <<< "$str"

É ISSO...
Marcelo Oliver



01 02 03



Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts