OS and Software > All Things Unix > Make variables uppercase in bash.

reply to pflog

Re: Make variables uppercase in bash.

oh ok! cool, should do the trick.

I think I may need to be a little more specific. We are writing a bash script that reads some stuff and builds a control file for Oracle's sqlldr, and then we execute sqlldr with the build control file. Our code looks much like this:

   if [ "${LINE}" = "amico.990120" ];  then       
      echo Building amic control file for ${LINE}
      echo LOAD DATA               > file_loader.ctl
      echo INFILE \'${LINE}\'      >> file_loader.ctl
      echo APPEND                  >> file_loader.ctl
      echo INTO TABLE schema.table >> file_loader.ctl
      echo "("                     >> file_loader.ctl
      echo " column1(1:2),"        >> file_loader.ctl
      echo " column2(3:4),"        >> file_loader.ctl
      echo " column3 CONSTANT '" ${LINE:4:1} | tr 'a-z' 'A-Z' "'," >> file_loader.ctl
      echo ")"                     >> file_loader.ctl
      sqlldr user/pass@database file_loader.ctl log=sqlldr.log silent=FEEDBACK
    else
      echo No Amic file found
    fi
  done < myAmicFiles
 

Looks like a good place for a perl script.

reply to Maxo
So in this line:

quote:

---

echo " column3 CONSTANT '" ${LINE:4:1} | tr 'a-z' 'A-Z' "'," >> file_loader.ctl

---

reply to Maxo
Probably the easiest thing to do would be to set a variable for the letter first, then just use that variable.

e.g instead of:

bash code:

echo " column3 CONSTANT '" ${LINE:4:1} | tr 'a-z' 'A-Z' "'," >> file_loader.ctl

the_char=`echo ${LINE:4:1} | tr a-z A-Z`
echo " column3 CONSTANT '$the_char'," >> file_loader.tcl

the_char=`echo ${LINE:4:1} | tr a-z A-Z`
The above line just returns the given string literal, not the results of the echo.