Solved

String search in NAWK

Posted on 2004-10-09
3
511 Views
Last Modified: 2006-11-17
Hi,

I'm trying to have user type in a name to search for, then have it read the variable.  I need it to match exactly, thus cant use grep as they would get results by typing in 'smit' when 'smith' exists in database. Below is my nawk command. Any ideas where I'm going wrong?


#!/usr/bin/ksh

# Search by Name
sleep 2
clear
cat flight.data | tr [a-z] [A-Z] > flight.data #Change data file to UPPERCASE

echo "What Last Name do you want to search for: \n"
read lname

LNAME=$lname

#nawk -F"," -v NAME=`cat lnametr` '$ 1== NAME { print }'  flight.data >
found=nawk -F"," -v '$ 1 == LNAME { print }'  flight.data >

#found=`grep -i "^$lname" flight.data`
if [ "$found" != "" ]

then

echo "\n\nName Found \n\n"

else

echo "\n\nThe Last Name" $lname "was not found \n\n
         Returning you to Last Name search  \n" ; ./name.ksh
            

fi




echo "$lname" | tr [a-z] [A-Z] > lnametr

NAME=`cat lnametr`
nawk -F"," -v NAME=`cat lnametr` '$ 1== NAME { print }'  flight.data > newflight.data

echo "\n\nWhat field would you like to sort your results by: \n\n
      1) Last Name \n
      2) First Name \n
      3) Departure City \n
      4) Arrival City \n
      5) Flight Number \n
      6) Departure Date \n"


read srtfld

clear

case "$srtfld" in

      1)sort +0 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      2)sort +1 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      3)sort +2 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      4)sort +3 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      5)sort +4 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      6)sort +6 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
      *) echo "\007\007\007 Invalid Option.  Sorting by default 'Last Name' \n"
             sort +0 -t, newflight.data > lstname.rpt ; ./lstname.report
            ;;
            
esac

echo "\n\nWould you like to do another search by Last Name: \n"
read ansnamesrch
case "$ansnamesrch" in
      y*|Y*)  ./name.ksh
            ;;
    *)  
      echo "Retuning to Main Menu: \n"
      sleep 2 ; clear ; ./menu.ksh
      ;;
esac
0
Comment
Question by:elwayisgod
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
tfewster earned 125 total points
ID: 12268575
Enclose the command in backticks + assign the passed pariable on the awk command line:
found=`nawk -F"," -v LNAME=$lname '$1 == LNAME { print }'  flight.data`

Incidentally, it would help if you said what the problem or error was and just post the code snippet that is giving you trouble ;-)

BTW, I suspect you might run into problems with
cat flight.data | tr [a-z] [A-Z] > flight.data
- if flight.data is a large file, there's a risk the output will overwrite the file before it's been fully read
Safer to do
cat flight.data | tr [a-z] [A-Z] > flight.data.new && mv flight.data.new flight.data

0
 

Author Comment

by:elwayisgod
ID: 12269136
Cant get it to assign found correctly. It just hangs on the last cat statement.  I'm stuck. All help is appreciated.  What I'm trying to do put in a variable in any case and if it matches exactly to the first field in the depart_flight.data file, then print those lines to a new file called flight.data, then I do a report etc....


#!/usr/bin/ksh

# Search by Departure city
clear
cat flight.data | tr [a-z] [A-Z] > flight.data #Change data file to UPPERCASE

echo "Enter the 3 character Departure City airport code to search for: \n"
read depcty
sleep 2
clear

nawk -F"," '{ print $3","$1","$2","$4","$5","$6","$ }' flight.data > flight.data
#cat depart_flight.data
#found=`grep -iw "depcty$" depart_flight.data`

echo "$depcty" | tr [a-z] [A-Z] > depctytr
found=`nawk -F"," -v DEPCITY=depctytr '$1 == DEPCITY { print }'  flight.data`
cat $found

0
 
LVL 20

Expert Comment

by:tfewster
ID: 12269164
echo "$depcty" | tr [a-z] [A-Z] > depctytr              # Creates a _file_ called "depctytr" containing the output of the echo command.
I suspect you want
depctytr=`echo "$depcty" | tr [a-z] [A-Z]`

found=`nawk -F"," -v DEPCITY=depctytr.........       # passes the _string_ "depctytr" to awk; You want $depctytr, i.e. the contents of the _variable_ depctytr.  As it is, $found will be the empty string as the string "depctytr" is NOT in flight.data

cat $found                  # cat the _file_  whose name matches the contents of $found, e.g. LAX;  Is this what you wanted?  However, due to the errors above, $found="" so `cat` waits for input
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question