thx reply ,

I tried to merge the script to as below

-------------------------------------------------
#!/bin/bash

MyString="abc\.)%@"

Total=0
GetData () {
AwkMyString="$( sed -e 's/[\/*?.+{}]/\\&/g' -e 's/[[]/\\&/g' -e 's/[]]/\\&/g' <<< "${MyString}" )"
for File in *.txt;do
Date="$(date "+%b %Y" --date="${File:4:6}01")"
awk 'BEGIN{C=0}{for (i=1;i<=NF;i++) if ( $i ~ /'${AwkMyString}'/ ){C++}} END{printf "%s %s?","'"${Date}"'",C}' "$File"
done
}
while read -d '?' Month Year Count;do
TableDate+=("${Month} ${Year}")
TableCount+=("${Count}")
done <<< $(GetData)

printf "%10s" "|"
for i in $(seq 0 $(( ${#TableDate[@]} - 1 )) );do
printf "%s |" "${TableDate[$i]}"
done
printf " Total |\n"


for i in $(seq 0 $(( ${#TableCount[@]} +1 )) );do
printf "=========|"
done
printf "\n"
printf "%10s" "|"
for i in $(seq 0 $(( ${#TableCount[@]} - 1 )) );do
printf "%*s%*s" $(( $((11 + ${#TableCount[$i]}))/2 )) "${TableCount[$i]}" $(( $((10 - ${#TableCount[$i]}))/2 )) "|"
done
for i in $(seq 0 $(( ${#TableCount[@]} - 1 )) );do
Total=$(( ${TableCount[$i]} + ${Total} ))
done
printf "%*s%*s" $(( (11 + ${#Total})/2 )) "${Total}" $(( (10 - ${#Total})/2 )) "|"

-------------------------------------------------

but got the result as below , the heading is duplicated , I tried many modification but still not work , would you help to fix it ? thanks

|Oct 2013 | Total |
=========|=========|=========|
| 14 | 14 | |Oct 2013 |Oct 2013 | Total |
=========|=========|=========|=========|
| 14 | 14 | 28

no code tags

===============

is a dumb and inferior substitute

I am not understand the meaning , you mean change === to ---- ?
I have done it

done what?

ahh, I see

you changed

==========
your code
==========
to
----------
your code
----------

which is still dumb,

I can/will not help you if you fail to follow simple instruction (post 26)

too late now , all too simple.. work it out yourself

As mentioned, please post code, data in code tags as per https://www.linuxquestions.org/quest...do=bbcode#code

Hi all ,

I think the below format is correct .

My current problem is when run the above script , I got the result as below , the heading is duplicated , I tried many modification but still not work , would you help to fix it ? thanks

|Oct 2013 | Total |
=========|=========|=========|
| 14 | 14 | |Oct 2013 |Oct 2013 | Total |
=========|=========|=========|=========|
| 14 | 14 | 28

Hi ,

I tried to remark each for loop to test it , but still not work .

I think the script is nearly complete , would you please help for it , very thanks