Renaming file names

Shell Programming and Scripting
1

I have 7 files with 7 different names coming into a specified folder on weekly basis, i need to pick a file one after another and load into oracle table using sql loader. I am using ksh to do this. So in the process if the file has error records and if sql loader fails to load into oracle tables, ksh should create an error file with a predefined name for each input file. i am able create an error file with a name.
so for example:
say 7 input file names as:
A.txt
B.txt
C.txt
D.txt
E.txt
F.txt
i am having an output file with name error.txt, this should be renamed to
for input file A.txt then G.txt
B.txt then H.txt
C.txt then I.txt
D.txt then J.txt
E.txt then K.txt
F.txt then L.txt
Any help is appreciated. Thank you!

2

Given an INPUT, this can choose the file to rename it to based on its first letter:

INPUT="A.txt"
NEW="$(tr '[A-F]' '[G-L]' <<< ${INPUT:0:1}).txt"
echo mv "$INPUT" "$NEW"
3

Guess the error.txt will be generated automatically.

cat error.txt

A.txt then G.txt
B.txt then H.txt
C.txt then I.txt
D.txt then J.txt
E.txt then K.txt
F.txt then L.txt

P=/XXX/XXX
ERR=/tmp/error.txt

for file in $(ls $P/*.txt)
do
  new=$(grep $file $ERR|awk '{print $3}')
  mv $file $new
done