Shell Programming and Scripting

 
sed '
  s/^[^,]*,[^,]*,\([^,]*\),[^,]*,[^,]*,\([^,]*\).*/\1 \2/
 '

cat `ls -r | head -2 | tail -1` | cut -d',' -f3,6

 
#!c:\perl\bin\perl.exe
 
#File Directory
$file_dir="C:\\log";
 
# Get yesterdays file
$last_file=`ls -r $file_dir | head -2 | tail -1`;

#Get Column3 and column6
$all=`cat "$last_file" | cut -d',' -f3,6 | sort | uniq`;
print "$all";

$all=`cat "$file_dir\\$last_file" | cut -d',' -f3,6 | sort | uniq`;

$all=`cut -d "," -f3,6 $file_dir'\\'$last_file | sort | uniq`;