Shell Programming and Scripting

Customer_information_Detail_1111_201010.csv
Product_information_Detail_1111_201010.csv
Relation_information_Detail_1111_201010.csv

Customer_information_Detail_2222_201010.csv
Product_information_Detail_2222_201010.csv
Relation_information_Detail_2222_201010.csv

Customer_information_Detail_3333_201010.csv
Product_information_Detail_3333_201010.csv
Relation_information_Detail_3333_201010.csv

cat Customer_information_Detail_1111_201010.csv >> Customer_information_Detail.csv
cat Customer_information_Detail_2222_201010.csv >> Customer_information_Detail.csv
cat Customer_information_Detail_3333_201010.csv >> Customer_information_Detail.csv


cat Product_information_Detail_1111_201010.csv >> Product_information_Detail.csv
cat Product_information_Detail_2222_201010.csv >> Product_information_Detail.csv
cat Product_information_Detail_3333_201010.csv >> Product_information_Detail.csv

cat Relation_information_Detail_1111_201010.csv >Relation_information_Detail.csv
cat Relation_information_Detail_2222_201010.csv >Relation_information_Detail.csv
cat Relation_information_Detail_3333_201010.csv >Relation_information_Detail.csv

Filename.out contains 
Customer_information_
Product_information_
Relation_information_

#!/bin/sh
for file in `cat Filename.out`
do
    Var=`echo $file"Detail`
    echo $Var
    for file1 in `ls |grep $Var`
    do
      cat $file* >>$file1.in
done
done

for i in Customer_information_Detail_*csv; do cat $i >> Customer_information_Detail.csv; done
for i in Product_information_Detail_*csv; do cat $i >> Product_information_Detail.csv; done
for i in Relation_information_Detail_*csv; do cat $i >> Relation_information_Detail.csv; done

#!/bin/sh

while read file; do
Var=`echo "$file"Detail`
for file1 in $Var*
do
cat $file1 >> $(echo $Var | awk -F_ '{print $1"_"$2"_"$3".csv"}')
done
done <Filename.out

Custo_To_Cust_Info_Rela_Detail_1212_200001.csv
Custo_To_Detail_1212_200001.csv
Prod_To_Cust_Info_Rela_Detail_1212_200001.csv
Prod_To_Detail_1212_200001.csv

Custo_To_Cust_Info_Rela_Detail.csv
Custo_To_Detail.csv
Prod_To_Cust_Info_Rela_Detail.csv
Prod_To_Detail.csv

Custo_To_Cust.csv
Custo_To_Detail.csv
Prod_To_Cust.csv
Prod_To_Detail.csv

while read file; do
  Var=`echo "$file"Detail`
  for file1 in $Var*
  do
    echo $file1

    cat $file1 >> $(echo $Var | awk -F_ '{print $1"_"$2"_"$3".csv"}')
  done
done <filename.out

Custo_To_Cust_Info_Rela_Detail
Custo_To_Detail
Prod_To_Cust_Info_Rela_Detail
Prod_To_Detail

while read file; do
 for file1 in $file*; do
 cat $file1 >> $(echo $file1 | sed 's/_[0-9].*/\.csv/')
 done
done <filename.out

awk '{sub(/_[0-9]*_[0-9]*/, "",FILENAME);print> FILENAME;}' *.csv