> -----Original Message-----
> From: wingators@xxxxxxxxx
> Sent: Mon, 9 May 2016 11:39:56 -0800
> To: users@xxxxxxxxxxxxxxxxxxxxxxx
> Subject: Re: using awk for selective printing, and adding a new line
>
>
>
>> -----Original Message-----
>> From: ad+lists@xxxxxxxxx
>> Sent: Mon, 9 May 2016 20:47:49 +0200
>> To: users@xxxxxxxxxxxxxxxxxxxxxxx
>> Subject: Re: using awk for selective printing, and adding a new line
>>
>> Am 09.05.2016 um 18:24 schrieb Antonio Olivares:
>>> 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
>>
>>
>> If you manage that the club names are always single fields of a
>> reasonable length, then
>>
>> awk '{ for (i = 1; i <= NF; i++) if (i % 10) printf "%s\t", $i; else
>> printf "%s\n", $i }' $yourinputfile
>>
>> does what you want.
>>
>> Alexander
>>
>> --
>
> It is getting close but some formatting is messing it up
> I tried
>
> $ awk 'ORS=NR%10?" ":"\n"' $filename
>
> it looked like it was going to work, but then in the first line, the PTS
> and the 1 got tangled up. Thank you for your insight it is close. I
> might need to use tr -d '\n' filename and pipe this and it could work.
>
> Best Regards,
>
>
> Antonio
>
awk '{ for (i = 1; i <= NF; i++) if (i % 10) printf "%s\t", $i; else printf "%s\n", $i }'
worked :)
Dear folks,
I saw a mistake. The command worked, I saw that the names were split into two and that messed things up. By fixing the names into one, the command works. Thank you very much for your help.
Best Regards,
Antonio
____________________________________________________________
Can't remember your password? Do you need a strong and secure password?
Use Password manager! It stores your passwords & protects your account.
Check it out at http://mysecurelogon.com/manager
--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
http://lists.fedoraproject.org/admin/lists/users@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: http://fedoraproject.org/code-of-conduct
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org
