Cacher is the code snippet organizer for pro developers

#!/bin/bash

gawk '
BEGIN {
  FS = "\t";
}
$7 == 1 {
  print $6 " " strftime("%Y%m%d", substr($15, 0, length($15) - 3));
}
' $1