awk Selective printing of fields

Shell Programming and Scripting
1

Hi Gurus,

I have following input file. I tried multiple awk combinations to print selected columns without success.

HEX ID    Name      ver  FLRGT Start Time               Total      Shared         End Date
----- --------   --- ------ ------------------------   -------------- ------- ------------------------ 
0006D cad abcName 0  .X... Fri Apr 21 17:56:07 2017      10327       1062                           NA
      opp klmName 3  ..... Mon Apr 17 20:15:19 2017      10364         41     Wed May  3 19:58:38 2017
      yu xyzName  49 ..... Wed Apr 12 19:56:49 2017      13717       3394                           NA
0006E cad abcName 1  .X... Fri Apr 21 17:56:07 2017      10491       1061                           NA
      ret qqqName 2  ..... Mon Apr 17 20:15:19 2017      10531         39     Wed May  3 19:58:38 2017
      ghy qqqName 4  ..... Wed Apr 12 19:56:49 2017      13882       3390                           NA
0006F mnb qqqName 32 .X... Fri Apr 21 17:56:07 2017      10385       1075                           NA
      opp klmName 7  ..... Mon Apr 17 20:15:19 2017      10420         43     Wed May  3 19:58:38 2017
      tyu qqqName 5  ..... Wed Apr 12 19:56:49 2017      13773       3396                           NA
0013F qdy qqqName 12 ..X.. Thu Feb  9 22:39:19 2017     724858     724858                           NA
                                                                           ---------- ----------
                                                                            156125212   39586208

I am expecting output as follows: Would appreciate your help.

 Name      ver  FLRGT Start Time                End Date																			
--------   --- ------ ------------------------ ------------------------ 
cad abcName 0  .X... Fri Apr 21 17:56:07 2017                        NA
opp klmName 3  ..... Mon Apr 17 20:15:19 2017  Wed May  3 19:58:38 2017
yu xyzName  49 ..... Wed Apr 12 19:56:49 2017                        NA
cad abcName 1  .X... Fri Apr 21 17:56:07 2017                        NA
ret qqqName 2  ..... Mon Apr 17 20:15:19 2017  Wed May  3 19:58:38 2017
ghy qqqName 4  ..... Wed Apr 12 19:56:49 2017                        NA
mnb qqqName 32 .X... Fri Apr 21 17:56:07 2017                        NA
opp klmName 7  ..... Mon Apr 17 20:15:19 2017  Wed May  3 19:58:38 2017
tyu qqqName 5  ..... Wed Apr 12 19:56:49 2017                        NA
qdy qqqName 12 ..X.. Thu Feb  9 22:39:19 2017                        NA

Thanks in advance.

2

Please show your attempts "without success" and the failure modes and reasons.

3

Hi RudiC,

Please my attempts below

1st attempt:

cat filename99 |awk '{
if (NF > 13)
print $0 |cut -f 1 -d '
else
print $0
}'

I get following o/p

HEX ID    Name      ver  FLRGT Start Time               Total      Shared         End Date
----- --------   --- ------ ------------------------   -------------- ------- ------------------------
0006D cad abcName 0  .X... Fri Apr 21 17:56:07 2017      10327       1062                           NA
      yu xyzName  49 ..... Wed Apr 12 19:56:49 2017      13717       3394                           NA
0006E cad abcName 1  .X... Fri Apr 21 17:56:07 2017      10491       1061                           NA
      ghy qqqName 4  ..... Wed Apr 12 19:56:49 2017      13882       3390                           NA
0006F mnb qqqName 32 .X... Fri Apr 21 17:56:07 2017      10385       1075                           NA
      tyu qqqName 5  ..... Wed Apr 12 19:56:49 2017      13773       3396                           NA
0013F qdy qqqName 12 ..X.. Thu Feb  9 22:39:19 2017     724858     724858                           NA
                                                                           ---------- ----------
                                                                            156125212   39586208
4

Difficult to believe you get that output ...
How about

cut -c7-51,74- file
    Name      ver  FLRGT Start Time                   End Date
--------   --- ------ --------------------------- ------------------------ 
cad abcName 0  .X... Fri Apr 21 17:56:07 2017                           NA
opp klmName 3  ..... Mon Apr 17 20:15:19 2017     Wed May  3 19:58:38 2017
yu xyzName  49 ..... Wed Apr 12 19:56:49 2017                           NA
cad abcName 1  .X... Fri Apr 21 17:56:07 2017                           NA
ret qqqName 2  ..... Mon Apr 17 20:15:19 2017     Wed May  3 19:58:38 2017
ghy qqqName 4  ..... Wed Apr 12 19:56:49 2017                           NA
mnb qqqName 32 .X... Fri Apr 21 17:56:07 2017                           NA
opp klmName 7  ..... Mon Apr 17 20:15:19 2017     Wed May  3 19:58:38 2017
tyu qqqName 5  ..... Wed Apr 12 19:56:49 2017                           NA
qdy qqqName 12 ..X.. Thu Feb  9 22:39:19 2017                           NA
                                               ---------- ----------
                                                156125212   39586208
1 Like
5

Thanks for your help RudiC