Dear folks,
I have found numerous guides using awk to format stats. I can get stats from a website,
but when I paste them they get pasted one per line, I can get them to one line using awk
'{printf("%s ",$0)}' and the filename here, but what I want to do is to
get the first 11 records and print out a new line "\n", then get the next 11
record and get new line "\n"
I get the data from
mediotiempo.com,
data:
Pos. Equipo JJ JG JE JP GF GC DIF PTS 1
Monterrey 17 12 1 4 38 23 15 37 2 Pachuca
17 8 6 3 31 16 15 30 3 León 17 9
3 5 29 19 10 30 4 América 17 8 5
4 34 22 12 29 5 Chivas 17 7 7 3 26 16
10 28 6 Morelia 17 8 4 5 25 24 1
28 7 Santos 17 8 3 6 22 20 2 27 8 Tigres
17 6 6 5 29 19 10 24 9 Cruz Azul 17
5 7 5 25 24 1 22 10 Pumas 17 5 7
5 23 24 -1 22 11 Toluca 17 5 7 5
20 21 -1 22 12 Puebla 17 5 7 5 21 26
-5 22 13 Club Querétaro 17 5 4 8 21 26
-5 19 14 Club Tijuana 17 3 9 5 17 26 -9
18 15 Atlas 17 3 5 9 18 26 -8 14 16 Dorados
17 4 2 11 18 32 -14 14 17 Veracruz 17
2 8 7 18 34 -16 14 18 Chiapas FC 17 3
3 11 16 33 -17 12
to
Pos Equipo JJ JG JE JP GF GC DIF PTS
1 Monterrey 16 12 1 3 37 21 16 37
2 America 16 8 4 4 33 21 12 28
3 Pachuca 16 7 6 3 29 15 14 27
4 Leon 16 8 3 5 28 19 9 27
5 Santos 16 8 3 5 22 19 3 27
6 Chivas 16 6 7 3 25 16 9 25
7 Morelia 16 7 4 5 23 23 0 25
8 CruzAzul 16 5 7 4 25 21 4 22
9 Tigres 16 5 6 5 26 19 7 21
10 Pumas 16 5 6 5 22 23 -1 21
11 Toluca 16 4 7 5 18 20 -2 19
12 ClubQueretaro 16 5 4 7 20 23 -3 19
13 Puebla 16 4 7 5 18 25 -7 19
14 ClubTijuana 16 3 8 5 17 26 -9 17
15 Dorados 16 4 2 10 18 31 -13 14
16 Veracruz 16 2 8 6 17 32 -15 14
17 Atlas 16 3 4 9 18 26 -8 13
18 ChiapasFC 16 3 3 10 15 31 -16 12
using a sed command.
I have parts of commands as follows:
#!/bin/sh
# Check for arguments
if [ $# -eq 0 ]; then
echo "Usage: $(basename $0) filename"
exit 1
fi
if [ ! -f $1 ]; then
echo "File "$1" doesn't exist!"
exit 0
fi
awk '
NR == 1 {
printf "%2s %-14s %3s %3s %3s %3s %3s %3s %3s %3s \n",
"Pos", "Equipo", "JJ", "JG",
"JE", "JP", "GF", "GC" , "DIF",
"PTS"
}
NR >= 2 {
printf "%2d %-14s %3d %3d %3d %3d %3d %3d %3d %3d \n",
$1, $2, $3, $4, $5, $6, $7, $8, $9, $10 '\n'
}' $1
but it just prints the first line and that is it because it treats the data as a single
line. If that is possible otherwise I will have to do it manually.
Best regards,
Antonio
____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and family!
Visit
http://www.inbox.com/photosharing to find out more!