AWK doubt

27/05/2007, 13h07

Hi:
Can you explain me why command below fail ?
(Doesn´t catch error 41 in file jobs4.lis)

Solaris> cat jobs4.lis | grep -i "`date +%m/%d/07`" | awk 'substr($0,
50, 4) + 0 > 1'
Solaris>

Solaris> cat jobs4.lis

207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0
207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0
207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0
207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
23:00 009:52:26 OXMTZS2K3057 0 F 0
207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
23:00 009:52:27 OXMTZS2K3058 0 F 0
207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
23:00 009:52:29 SMMTZS2K3115 0 F 0
207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58
05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0
207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50
05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0
207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49
05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0
207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44
05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0

Thanks

27/05/2007, 13h32

apogeusistemas@gmail.com wrote:
> Hi:
> Can you explain me why command below fail ?

Because you started the program today, but the logfile entry would match
only the date yesterday?

Your program works for me (with dates adjusted).

> (Doesn´t catch error 41 in file jobs4.lis)
>
> Solaris> cat jobs4.lis | grep -i "`date +%m/%d/07`" | awk 'substr($0,
> 50, 4) + 0 > 1'

BTW, cat is unnecessary and -i is unnecessary and grep can be done by awk.

awk -v d=$(date +'%m/%d/07') '$0~d && substr($0,50, 4) + 0 > 1' jobs4.lis

Also, if there are no whitespace characters in any of the first four
fields you can as well compare against the fields (instead of substring)

awk -v d=$(date +'%m/%d/07') '$0 ~ d && $5 > 1' jobs4.lis

Janis

> Solaris>
>
> Solaris> cat jobs4.lis
>
> 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0
> 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0
> 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0
> 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:26 OXMTZS2K3057 0 F 0
> 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:27 OXMTZS2K3058 0 F 0
> 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:29 SMMTZS2K3115 0 F 0
> 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58
> 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0
> 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50
> 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0
> 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49
> 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0
> 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44
> 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0
>
>
> Thanks
>

27/05/2007, 13h36

apogeusistemas@gmail.com wrote:
> Hi:
> Can you explain me why command below fail ?
> (Doesn´t catch error 41 in file jobs4.lis)
>
> Solaris> cat jobs4.lis | grep -i "`date +%m/%d/07`" | awk 'substr($0,
> 50, 4) + 0 > 1'

Ah! Wait...

> Solaris>

Have you tried one of the other solaris awk's (e.g. /usr/xpg4/bin/awk)?

Janis

>
> Solaris> cat jobs4.lis
>
> 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0
> 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0
> 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0
> 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:26 OXMTZS2K3057 0 F 0
> 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:27 OXMTZS2K3058 0 F 0
> 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> 23:00 009:52:29 SMMTZS2K3115 0 F 0
> 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58
> 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0
> 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50
> 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0
> 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49
> 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0
> 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44
> 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0
>
>
> Thanks
>

29/05/2007, 14h14

On 27 maio, 09:36, Janis Papanagnou <Janis_Papanag...@hotmail.com>
wrote:
> apogeusiste...@gmail.com wrote:
> > Hi:
> > Can you explain me why command below fail ?
> > (Doesn´t catch error 41 in file jobs4.lis)
>
> > Solaris> cat jobs4.lis | grep -i "`date +%m/%d/07`" | awk 'substr($0,
> > 50, 4) + 0 > 1'
>
> Ah! Wait...
>
> > Solaris>
>
> Have you tried one of the other solaris awk's (e.g. /usr/xpg4/bin/awk)?
>
> Janis
>
>
>
>
>
> > Solaris> cat jobs4.lis
>
> > 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> > 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0
> > 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> > 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0
> > 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00
> > 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0
> > 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> > 23:00 009:52:26 OXMTZS2K3057 0 F 0
> > 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> > 23:00 009:52:27 OXMTZS2K3058 0 F 0
> > 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07
> > 23:00 009:52:29 SMMTZS2K3115 0 F 0
> > 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58
> > 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0
> > 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50
> > 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0
> > 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49
> > 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0
> > 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44
> > 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0
>
> > Thanks- Ocultar texto entre aspas -
>
> - Mostrar texto entre aspas -

Thank you , Janis !

27/05/2007, 13h07	#1
apogeusistemas@gmail.com Messages: n/a Hébergeur:	AWK doubt Hi: Can you explain me why command below fail ? (Doesn´t catch error 41 in file jobs4.lis) Solaris> cat jobs4.lis \| grep -i "`date +%m/%d/07`" \| awk 'substr($0, 50, 4) + 0 > 1' Solaris> Solaris> cat jobs4.lis 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 23:00 009:52:26 OXMTZS2K3057 0 F 0 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 23:00 009:52:27 OXMTZS2K3058 0 F 0 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 23:00 009:52:29 SMMTZS2K3115 0 F 0 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0 Thanks

27/05/2007, 13h32	#2
Janis Papanagnou Messages: n/a Hébergeur:	Re: AWK doubt apogeusistemas@gmail.com wrote: > Hi: > Can you explain me why command below fail ? Because you started the program today, but the logfile entry would match only the date yesterday? Your program works for me (with dates adjusted). > (Doesn´t catch error 41 in file jobs4.lis) > > Solaris> cat jobs4.lis \| grep -i "`date +%m/%d/07`" \| awk 'substr($0, > 50, 4) + 0 > 1' BTW, cat is unnecessary and -i is unnecessary and grep can be done by awk. awk -v d=$(date +'%m/%d/07') '$0~d && substr($0,50, 4) + 0 > 1' jobs4.lis Also, if there are no whitespace characters in any of the first four fields you can as well compare against the fields (instead of substring) awk -v d=$(date +'%m/%d/07') '$0 ~ d && $5 > 1' jobs4.lis Janis > Solaris> > > Solaris> cat jobs4.lis > > 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0 > 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0 > 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0 > 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:26 OXMTZS2K3057 0 F 0 > 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:27 OXMTZS2K3058 0 F 0 > 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:29 SMMTZS2K3115 0 F 0 > 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58 > 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0 > 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50 > 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0 > 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49 > 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0 > 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44 > 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0 > > > Thanks >

27/05/2007, 13h36	#3
Janis Papanagnou Messages: n/a Hébergeur:	Re: AWK doubt apogeusistemas@gmail.com wrote: > Hi: > Can you explain me why command below fail ? > (Doesn´t catch error 41 in file jobs4.lis) > > Solaris> cat jobs4.lis \| grep -i "`date +%m/%d/07`" \| awk 'substr($0, > 50, 4) + 0 > 1' Ah! Wait... > Solaris> Have you tried one of the other solaris awk's (e.g. /usr/xpg4/bin/awk)? Janis > > Solaris> cat jobs4.lis > > 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0 > 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0 > 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0 > 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:26 OXMTZS2K3057 0 F 0 > 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:27 OXMTZS2K3058 0 F 0 > 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > 23:00 009:52:29 SMMTZS2K3115 0 F 0 > 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58 > 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0 > 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50 > 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0 > 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49 > 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0 > 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44 > 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0 > > > Thanks >

29/05/2007, 14h14	#4
apogeusistemas@gmail.com Messages: n/a Hébergeur:	Re: AWK doubt On 27 maio, 09:36, Janis Papanagnou <Janis_Papanag...@hotmail.com> wrote: > apogeusiste...@gmail.com wrote: > > Hi: > > Can you explain me why command below fail ? > > (Doesn´t catch error 41 in file jobs4.lis) > > > Solaris> cat jobs4.lis \| grep -i "`date +%m/%d/07`" \| awk 'substr($0, > > 50, 4) + 0 > 1' > > Ah! Wait... > > > Solaris> > > Have you tried one of the other solaris awk's (e.g. /usr/xpg4/bin/awk)? > > Janis > > > > > > > Solaris> cat jobs4.lis > > > 207245 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > > 05/27/07 05:54 006:19:04 UCMTZS2K055 2537 F 0 > > 207244 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > > 05/27/07 08:34 009:06:12 TUMTZS2K050 3047 F 0 > > 207243 WIN_DIARIO_23 Backup Done 0 05/26/07 23:00 > > 05/27/07 07:42 008:42:44 OXMTZS2K036 2816 F 0 > > 207241 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > > 23:00 009:52:26 OXMTZS2K3057 0 F 0 > > 207240 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > > 23:00 009:52:27 OXMTZS2K3058 0 F 0 > > 207239 WIN_DIARIO_23 Backup Waiting-t 41 05/26/07 > > 23:00 009:52:29 SMMTZS2K3115 0 F 0 > > 207238 ORA_LX002_CORP_ON Backup Done 0 05/26/07 22:58 > > 05/26/07 23:37 000:38:25 smmtzslx002 41126 A 0 > > 207236 WIN_DIARIO_21 Backup Done 0 05/26/07 22:50 > > 05/27/07 01:14 002:23:48 OXMTZS2K3030 2741 F 0 > > 207235 WIN_DIARIO_21 Backup Done 1 05/26/07 22:49 > > 05/27/07 02:06 003:16:48 OXMTZS2K3081 2713 F 0 > > 207234 WIN_DIARIO_21 Backup Done 1 05/26/07 22:44 > > 05/27/07 01:40 002:55:48 OXMTZS2K3074 2723 F 0 > > > Thanks- Ocultar texto entre aspas - > > - Mostrar texto entre aspas - Thank you , Janis !

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email