Obtenir Une Line de Plusieurs Occurences Résolu/Fermé

Question

Bonjour, 

J'aimerais extraire la première ligne de plusieurs occurrences d'un fichier .

Merci d'avance 

Fichier de Base File1
26;;;;02/01/2018 09:18;02/01/2018 09:20;0:01:29;BCCH MISSING49;;;;02/01/2018 08:51;02/01/2018 09:15;0:24:12;BCCH MISSING49;;;;02/01/2018 08:51;02/01/2018 09:15;0:24:12;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:28;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:30;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:29;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:29;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:29;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:28;BCCH MISSING175;;;;02/01/2018 09:04;02/01/2018 09:04;0:00:01;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:45;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:44;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:45;BCCH MISSING1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:53;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:52;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:50;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:49;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:48;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:46;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:45;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:43;WCDMA CELL OUT OF USE1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:42;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:58;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:56;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:55;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:55;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:53;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:51;WCDMA CELL OUT OF USE

Resultat FILE2

26;;;;02/01/2018 09:18;02/01/2018 09:20;0:01:29;BCCH MISSING49;;;;02/01/2018 08:51;02/01/2018 09:15;0:24:12;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:28;BCCH MISSING175;;;;02/01/2018 09:04;02/01/2018 09:04;0:00:01;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:45;BCCH MISSING1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:53;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:58;WCDMA CELL OUT OF USE

Configuration: Windows / Chrome 64.0.3282.140

Utilisateur anonyme · Answer

salut,

en gros :
SI la ligne courante est semblable à la précédente,
ALORS passer à la suivante
AUTREment afficher la ligne courante
finSI

dubcek · Answer

hello
$ awk -F ";" '{t[NR]=$1} NR==1; NR>1 && $1 != t[NR-1] '  File126;;;;02/01/2018 09:18;02/01/2018 09:20;0:01:29;BCCH MISSING49;;;;02/01/2018 08:51;02/01/2018 09:15;0:24:12;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:28;BCCH MISSING175;;;;02/01/2018 09:04;02/01/2018 09:04;0:00:01;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:45;BCCH MISSING1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:53;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:58;WCDMA CELL OUT OF USE

GHISLINO · Answer

Hello Dubcek;

Merci infiniment pour ton feedback exactement ce que je recherchais.

Merci aussi à qqchquicommenceparQ 

Cdlt.

dubcek · Answer

plus court
$ awk -F ";" '$1 != n; {n=$1}' File126;;;;02/01/2018 09:18;02/01/2018 09:20;0:01:29;BCCH MISSING49;;;;02/01/2018 08:51;02/01/2018 09:15;0:24:12;BCCH MISSING26;;;;02/01/2018 09:13;02/01/2018 09:14;0:01:28;BCCH MISSING175;;;;02/01/2018 09:04;02/01/2018 09:04;0:00:01;BCCH MISSING49;;;;02/01/2018 08:43;02/01/2018 08:49;0:06:45;BCCH MISSING1263;;;;02/01/2018 05:46;02/01/2018 11:06;5:19:53;WCDMA CELL OUT OF USE1034;;;;02/01/2018 10:34;02/01/2018 10:38;0:03:58;WCDMA CELL OUT OF USE

Obtenir Une Line de Plusieurs Occurences

4 réponses

Discussions similaires