Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Can I use nawk -v with two or more variables?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Can I use nawk -v with two or more variables?
# 8  
Old 07-12-2010
In that case ( if I understood the requirement correctly),you don't have the matching criteria in your records.
None of the column 1 from file "here" matches with the column 2 of the file "new.txt".

As far as your command,
You have got variable mismatch ( CELLID and CID ). Please correct it. and also apply my suggestion in previous post.

Your script can also be written as:
Code:
while IFS="," read CID NAME
do
echo $CID $NAME
awk -F"," -v cid=$CID -v name=$NAME '{gsub(cid,name,$2); print $1","$2 }' new.txt >that.txt
done < here

If the output is not as per you expectation, please provide the sample output from the above file samples.

.
Last edited by clx; 07-12-2010 at 11:19 AM.. Reason: typo
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple bash variables passed into nawk

I have a file that has 2 fields called b_file: 11977 DAR.V3.20150209.1.CSV 3295 DAR.V3.20150209.1.CSV 1721 DAR.V2.20150210.1.CSV I need to search a sftplog using the field 1, but want to maintain the relationship between field 1 and 2. I am passing field 1 as a parameter in a bash loop. ... (14 Replies)
Discussion started by: smenago
14 Replies

2. Shell Programming and Scripting

Two shell variables using nawk

How do you use two shell variables in awk? I am using Solaris 10 and don't have GNU products installed. File (transportation.txt) contents: car make boat model airplane landing snowmobile track bicycle helmet sled housing Thanks to this forum this code works (prints everything from the... (4 Replies)
Discussion started by: thibodc
4 Replies

3. Shell Programming and Scripting

nawk variables

Hi - The following nawk is not working and trying to understand why! nawk -v t="internal_order" '/SAP_RM_ADMIN_SCHEMA/ && ("" toupper(t)) || /SAP_RM_ADMIN_SCHEMA/ && ("" tolower(t))' PBFD100.ksh My intention is to retrieve the line containing SAP_RM_ADMIN_SCHEMA.internal_order but its just not... (6 Replies)
Discussion started by: anduzzi
6 Replies

4. Shell Programming and Scripting

nawk - Unable to use 2 variables for NR range

Hi, I need to break an input file into multiple output files. The number of output files is decided by a maximum record count allowed for each file. Hence I am using the nawk command to recursively retrieve a range of lines from an input file and write them to output files. But I am unable to... (3 Replies)
Discussion started by: ragz_82
3 Replies

5. Shell Programming and Scripting

Passing the nawk variables to the shell

nawk '($1 ~ "1000") && ($1 ~ "5665" ) { sub ($6,"89");flag =1;print }' old.txt >> new.txt I want to set a flag in awk , if the both conditions are met. I want to pass this flag to shell Can anyone please help me on this (1 Reply)
Discussion started by: prav076
1 Replies

6. Shell Programming and Scripting

how to access values of awk/nawk variables outside the awk/nawk block?

i'm new to shell scripting and have a problem please help me in the script i have a nawk block which has a variable count nawk{ . . . count=count+1 print count } now i want to access the value of the count variable outside the awk block,like.. s=`expr count / m` (m is... (5 Replies)
Discussion started by: saniya
5 Replies

7. Shell Programming and Scripting

I can't seem to pass variables properly into a nawk statement

Ok, So up front I'm going to say that I'm a very elementary scripter, and I tend to use tools I don't fully understand, but I shotgun at something until I can get it to work...that said, I can't for the life of me understand why I can't get this to go down the way I want it to. The goal: -to... (6 Replies)
Discussion started by: DeCoTwc
6 Replies

8. Shell Programming and Scripting

nawk - Passing variables

Hi, I am passing the varibale using nawk -v to search the pattern from the file. But this variable is not accepting. I couldn't get the crrect output. Help me regarding..... nawk -v PGMNAME="$prog" ' { $0 ~ /PGMNAME/ { .................. ................. ... (3 Replies)
Discussion started by: sharif
3 Replies

9. Shell Programming and Scripting

Assigning nawk output to variables

I do a lot of command line scripting to capture data from files or other command output. I've checked in a number of Unix and scripting books but for the life of me I can't find out how to asign field data from nawk output into variables that I can manipulate later. For example, reading a two... (6 Replies)
Discussion started by: steveje0711
6 Replies

10. Shell Programming and Scripting

nawk and variables

Hi guy's Im trying to pass variables into nawk and then match them on a value within a record but it don't seem to be working. If i put in the dates i want to see then it works fine.. #!/usr/bin/ksh -x YEST=$(/usr/local/bin/perl -e... (8 Replies)
Discussion started by: plimpix
8 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

shtool-path

SHTOOL-PATH.TMP(1)					      GNU Portable Shell Tool						SHTOOL-PATH.TMP(1)

NAME

       shtool-path - GNU shtool command dealing with shell path variables

SYNOPSIS

       shtool path [-s|--suppress] [-r|--reverse] [-d|--dirname] [-b|--basename] [-m|--magic] [-p|--path path] str [str ...]

DESCRIPTION

       This command deals with shell $PATH variables. It can find a program through one or more filenames given by one or more str arguments.  It
       prints the absolute filesystem path to the program displayed on "stdout" plus an exit code of 0 if it was really found.

OPTIONS

       The following command line options are available.

       -s, --suppress
	   Supress output. Useful to only test whether a program exists with the help of the return code.

       -r, --reverse
	   Transform a forward path to a subdirectory into a reverse path.

       -d, --dirname
	   Output the directory name of str.

       -b, --basename
	   Output the base name of str.

       -m, --magic
	   Enable advanced magic search for ""perl"" and ""cpp"".

       -p, --path path
	   Search in path. Default is to search in $PATH.

EXAMPLE

	#   shell script
	awk=`shtool path -p "${PATH}:." gawk nawk awk`
	perl=`shtool path -m perl`
	cpp=`shtool path -m cpp`
	revpath=`shtool path -r path/to/subdir`

HISTORY

       The GNU shtool path command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for Apache. It was later taken
       over into GNU shtool.

SEE ALSO

       shtool(1), which(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-PATH.TMP(1)