#!/bin/bash rm -f sample.csv for i in `ls -1 *csv | sort -V` do AZ=`echo $i | cut -f 2 -d "-"` SAMPLE=`grep ", 400000000, " $i | head -1 | cut -f 7 -d " " | sed -e 's/,//g'` echo "$AZ, $SAMPLE" >> sample.csv done cat sample.csv