[Variables] Concaténation commande AWK

Version imprimable

Bonjour,

Comment garder les variables après une concaténation de AWK dans une boucle ?
Le 3 premières commandes sont là que pour expliquer le fonctionnement de la dernière commande.
Exemple

Fichier d'entrée tmp.lst
Code:

1 2 3 4 5 6 7 8 9 10 11 12 CC 22/04/2015 17:50 AAA140380170 OK 0 BB_4_1 batch CC 22/04/2015 17:50 AAA140380176 OK 0 BB_7_1 batch CC 22/04/2015 17:50 AAA140380178 OK 0 BB_4_1 batch CC 22/04/2015 17:50 AAA140380184 OK 0 BB_8_1 batch CC 22/04/2015 17:50 AAA140380186 OK 0 BB_5_1 batch CC 22/04/2015 17:50 AAA140380187 OK 0 BB_1_1 batch CC 22/04/2015 20:50 AAA140386716 OK 0 BB_2_1 batch CC 22/04/2015 20:50 AAA140386717 OK 0 BB_3_1 batch CC 22/04/2015 20:50 AAA140386718 OK 0 BB_4_1 batch CC 22/04/2015 20:50 AAA140386719 OK 0 BB_2_1 batch CC 22/04/2015 20:50 AAA140386720 OK 0 BB_3_1 batch CC 22/04/2015 20:50 AAA140386722 OK 0 BB_4_1 batch
Code:

cat tmp.lst |awk 'BEGIN {FS=" "} {print $4}'

AAA140380170
AAA140380176
AAA140380178
AAA140380184
AAA140380186
AAA140380187
AAA140386716
AAA140386717
AAA140386718
AAA140386719
AAA140386720
AAA140386722

Code:

cat tmp.lst |awk 'BEGIN {FS=" "} {print $7}'

BB_4_1
BB_7_1
BB_4_1
BB_8_1
BB_5_1
BB_1_1
BB_2_1
BB_3_1
BB_4_1
BB_2_1
BB_3_1
BB_4_1

Code:

cat tmp.lst |awk 'BEGIN {FS=" "} {print $4 "_" $7}'

AAA140380170_BB_4_1
AAA140380176_BB_7_1
AAA140380178_BB_4_1
AAA140380184_BB_8_1
AAA140380186_BB_5_1
AAA140380187_BB_1_1
AAA140386716_BB_2_1
AAA140386717_BB_3_1
AAA140386718_BB_4_1
AAA140386719_BB_2_1
AAA140386720_BB_3_1
AAA140386722_BB_4_1

Code:

for i in $( cat tmp.lst |awk 'BEGIN {FS=" "} {print $4 "_" $7}'|awk 'BEGIN {FS="_"} {print $2 $3}' ); do echo $i;done

BB4
BB7
BB4
BB8
BB5
BB1
BB2
BB3
BB4
BB2
BB3
BB4

A la suite de cette commande je souhaiterais faire une | grep en utilisant la variable $4 qui n'existe plus à la suite de la concaténation de AWK

Merci de votre aide

24/04/2015, 16h49
disedorgue

Bonjour,

Pas bien:

Code:

cat fichier | awk

Bien:

Code:

awk fichier

Pas bien:

Code:

awk '{print $4}' fichier

Bien:

Code:

cut -f4 fichier

awk est à utiliser dans le cas de test complexe, comme par exemple le grep que tu veux faire après, ici tout ce que tu demandes peut-être fais en un seul script awk...

Bonjour,

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
$ cat /tmp/test.txt
CC 22/04/2015 17:50 AAA140380170 OK 0 BB_4_1 batch
CC 22/04/2015 17:50 AAA140380176 OK 0 BB_7_1 batch
CC 22/04/2015 17:50 AAA140380178 OK 0 BB_4_1 batch
CC 22/04/2015 17:50 AAA140380184 OK 0 BB_8_1 batch
CC 22/04/2015 17:50 AAA140380186 OK 0 BB_5_1 batch
CC 22/04/2015 17:50 AAA140380187 OK 0 BB_1_1 batch
CC 22/04/2015 20:50 AAA140386716 OK 0 BB_2_1 batch
CC 22/04/2015 20:50 AAA140386717 OK 0 BB_3_1 batch
CC 22/04/2015 20:50 AAA140386718 OK 0 BB_4_1 batch
CC 22/04/2015 20:50 AAA140386719 OK 0 BB_2_1 batch
CC 22/04/2015 20:50 AAA140386720 OK 0 BB_3_1 batch
CC 22/04/2015 20:50 AAA140386722 OK 0 BB_4_1 batch

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
$ awk -F'[_ ]' '{print $7$8$4;}' /tmp/test.txt
BB4AAA140380170
BB7AAA140380176
BB4AAA140380178
BB8AAA140380184
BB5AAA140380186
BB1AAA140380187
BB2AAA140386716
BB3AAA140386717
BB4AAA140386718
BB2AAA140386719
BB3AAA140386720
BB4AAA140386722

Faire la même chose de différentes façons :
Code:

1 2 awk '{ print $4 "_" substr($7,"0","2") substr($7,"4","1") } ' /tmp/file.txt

Citation:

Envoyé par Flodelarab

Bonjour,

Code:

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
$ cat /tmp/test.txt
CC 22/04/2015 17:50 AAA140380170 OK 0 BB_4_1 batch
CC 22/04/2015 17:50 AAA140380176 OK 0 BB_7_1 batch
CC 22/04/2015 17:50 AAA140380178 OK 0 BB_4_1 batch
CC 22/04/2015 17:50 AAA140380184 OK 0 BB_8_1 batch
CC 22/04/2015 17:50 AAA140380186 OK 0 BB_5_1 batch
CC 22/04/2015 17:50 AAA140380187 OK 0 BB_1_1 batch
CC 22/04/2015 20:50 AAA140386716 OK 0 BB_2_1 batch
CC 22/04/2015 20:50 AAA140386717 OK 0 BB_3_1 batch
CC 22/04/2015 20:50 AAA140386718 OK 0 BB_4_1 batch
CC 22/04/2015 20:50 AAA140386719 OK 0 BB_2_1 batch
CC 22/04/2015 20:50 AAA140386720 OK 0 BB_3_1 batch
CC 22/04/2015 20:50 AAA140386722 OK 0 BB_4_1 batch
$ awk -F'[_ ]' '{print $7$8$4;}' /tmp/test.txt
BB4AAA140380170
BB7AAA140380176
BB4AAA140380178
BB8AAA140380184
BB5AAA140380186
BB1AAA140380187
BB2AAA140386716
BB3AAA140386717
BB4AAA140386718
BB2AAA140386719
BB3AAA140386720
BB4AAA140386722

Merci,
Ta commande ne marche pas chez moi car j'ai des tabulations au lieu des espaces.
Comment faire pour prendre en compte à la fois espaces et tabulations ?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
$ cat /tmp/test.txt
CC      22/04/2015 17:50 AAA140380170 OK 0 BB_4_1 batch
CC      22/04/2015 17:50 AAA140380176 OK 0 BB_7_1 batch
CC      22/04/2015 17:50 AAA140380178 OK 0 BB_4_1 batch
CC      22/04/2015 17:50 AAA140380184 OK 0 BB_8_1 batch
CC      22/04/2015 17:50 AAA140380186 OK 0 BB_5_1 batch
CC      22/04/2015 17:50 AAA140380187 OK 0 BB_1_1 batch
CC      22/04/2015 20:50 AAA140386716 OK 0 BB_2_1 batch
CC      22/04/2015 20:50 AAA140386717 OK 0 BB_3_1 batch
CC      22/04/2015 20:50 AAA140386718 OK 0 BB_4_1 batch
CC      22/04/2015 20:50 AAA140386719 OK 0 BB_2_1 batch
CC      22/04/2015 20:50 AAA140386720 OK 0 BB_3_1 batch
CC      22/04/2015 20:50 AAA140386722 OK 0 BB_4_1 batch

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
$ awk -F'[_ \t]' '{print $7$8$4;}' /tmp/test.txt
BB4AAA140380170
BB7AAA140380176
BB4AAA140380178
BB8AAA140380184
BB5AAA140380186
BB1AAA140380187
BB2AAA140386716
BB3AAA140386717
BB4AAA140386718
BB2AAA140386719
BB3AAA140386720
BB4AAA140386722