Fetching data particular data from the file.

Shell Programming and Scripting
1

Hi All,
I have one fine which contaning the record as below, I need to fetch the number which is in Bold and from second line only URL [which is in BOLD and its in other line] need to pick.

[02-Aug-14 16:04:00] :ABCD                 C7QyzBXIs58k                                  1                       fdmlksdlkfn
                                                https://wmknsm.pwddmslkf.com

                                                                                                                    [02-Aug-14 16:04:03] EFGH                      vl3E2smh2f2                                          200                    kljnsdkljfksdf   
                                                  https://msdnf.nbdsmnf.com/         
[02-Aug-14 16:04:08] IJKL                        AWn65mmn                                            500                                       klsdjflkjsdklf 
                                                   https://wlpqlml.mpc/cpr.htm

the new data or fetched data from the above file should be like...

https://wmknsm.pwddmslkf.com  1
https://msdnf.nbdsmnf.com/         200
 https://wlpqlml.mpc/cpr.htm         500

Please help.

2 
awk '
   NR%2 {match($0,/ [0-9]+ /); n=substr($0,RSTART,RLENGTH); next}
	{print $0, n}
' file
3

Try also

awk 'NR%2 {getline X; print X, $5}' file4
https://wmknsm.pwddmslkf.com 1
https://msdnf.nbdsmnf.com/ 200
https://wlpqlml.mpc/cpr.htm 500
4

Thanks ,but for both the code its giving a same error as below

# awk 'NR%2 {getline X; print X, $5}' test.log
awk: syntax error near line 1
awk: bailing out near line 1

#awk 'NR%2 {match($0,/ [0-9]+ /); n=substr($0,RSTART,RLENGTH); next} {print $2,5}' test.log
awk: syntax error near line 1
awk: bailing out near line 1

Pls help

5

Use nawk