Shell Programming and Scripting

Hello,

In a main shell script, I would be getting the Table name as one of parameter, I need to check whether that table name exist in a Static List, which will have 2 column (Table Name, Column Name) ,
If exist , then I will perform some activities , otherwise exit with no additional process.

For e-g , If the content of the file is

Code:

Table1              Field1
Table2              Field2
Table77            Field77……

In the main script , If Tablename = Table1, then I need to printf the column content from the list , in this case which would be ‘Field1’
I used the following code to check a list of tables in a specific folder, not sure how to check a specific input and check in a file.

Code:

#!/usr/bin/ksh
while read FILE
do
    [ -z "$FILE" ] && continue # ignore blank lines 
    [ -f "$checkfolder/${FILE}" ] && continue
 
        echo "$checkfolder/${FILE} is missing !" >&2     
            err_code=1
done < $path/tmp/$totalFile.lst
        exit $err_code

Please help
Thanks,

---------- Post updated at 02:07 PM ---------- Previous update was at 01:14 PM ----------

I just realised that the table name will appear only one time in the file list, I will better of use grep , something like

`grep $1 /export/home/fusionuk/main.lst | awk -F, '{print $2}'`

Thanks

You shouldn't use backticks, because they are deprecated and only supported to be backwards compatible. Use "$(....)" instead.

When you already use awk, you don't need grep, yes?

Code:

$(awk -F, '/'"$1"'/ {print $2}')

I hope this helps.

bakunin