Hi all,

I am writing a script to do some matching for the filename. Let say there are multiple files in a directory, the filename is like below

test.88
test2.88
test.99
test2.99
test3.99

For different file extension, different action will be taken. For example test.88 and test2.88 files will be load into one database, whereas test.99, test2.99 and test3.99 will be load into another database.

I tried to use the nawk to get the file extension like below but is not working.

for filename in `ls -l`
do
nawk 'BEGIN { FS="." }; { print $2 }' $filename
done

The print $2 didn't print the 88 or 99 extension. It just return me an empty value. Does anyone know what is going wrong here. Please advise.

Thank you so much.

BR,
Shirley

That is not a good way to process files. However the problem is that you used ls -l and assumed to always find 2 fields, on the first line of ls -l you will only have one field.

One better way would be:

for file in * ; do
    case $file in 
        *.88)
               do something;;
        *.99)
               do something else;;
    esac
done

Hi Reborg,

Here is my complete script.

#!/bin/ksh

DIR="/root/test/statbackup"

# Checking whether the directory exist or not

if [ -d "$DIR" ]; then
cd $DIR
else
print "ERROR: Directory doest not exist!"
fi

for file in * ; do
case $file in
*.88)

#LOAD the file into Test1 Database

mysql -uroot -ptecnomen teststat<<EOFMYSQL

LOAD DATA LOCAL INFILE '$DIR/$file' INTO TABLE test1 FIELDS TERMINATED BY '|'
IGNORE 1 LINES;
;;

*.99)

#LOAD the file into Test2 Database

mysql -uroot -ptecnomen teststat<<EOFMYSQL

LOAD DATA LOCAL INFILE '$DIR/$file' INTO TABLE test2 FIELDS TERMINATED BY '|'
IGNORE 1 LINES;
;;

*)
print "Usage: $file is not in correct format"
;;

esac
done

#Remove all the statbackup file

rm -r /root/test/statbackup/*

After I execute the script, I get error "syntax error:unexpected end of file".
I tried go into the script and the line that script complaint actually is not occur, meaning one line more than the maximum script line. I really dont know how to solve on this. Please advise.

Thank you so much.

BR,
Shirley

Put your code in code tags, and if possible, indent your code for readability.
back to your script, you used HERE document, << EOFMYSQL, but you left out the closing pair.

case .....
...
     LOAD DATABASE ... <<EOFMYSQL
....
...
EOFMYSQL
..
;;
...
esac

Hi ghostdog74,

Thank you so much for your advise.

The code become so messy and difficult to read after I copy it into here.
So sorry about it.

I added in the closing pair for EOFMYSQL and tried to execute the script. The same error still prompt out.

Is it ok to load the data into databse by using Case statement?

Tried to execute the script by sh -x statbackup.ksh, but it didnt show where is the error, just prompt "unexpected end of file". Please advise.

Thank you so much.

Br,
Shirley

show the code you have. this time with code tags.