04-03-2007
Yes that would help. you can tell I am a newbie. Works great. I changed it slightly but it works.
awk -F'|' '
NR==FNR { arr[$1]=1; next }
arr[$1] !=1' $HOME/$WORK/$NewFile $HOME/$COMPARE/$OldFile > $HOME/$WORK/$NewFile.del
The above compares yesterdays file to todays and find deleted records.
Thanks very much for the help.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i would like to pass a variable to awk wherein the variable comes from external loop.
i tried this...
let x=0
until test $x -eq 32
do
cat file | awk '{ print $1 , "Number" , $($x) }' >> output
done
thanks, (4 Replies)
Discussion started by: inquirer
4 Replies
2. Shell Programming and Scripting
I am trying to pass 2 shell variable's ("START" and "END") define earlier in the script to this awk statement, but i can't seem to pass it on. PLs help.
set START = xxxx
set END = yyyy
set selected_file = `awk '/$START/,/$END/' filename` (24 Replies)
Discussion started by: Raynon
24 Replies
3. Shell Programming and Scripting
HI all,
some more mistery about AWK, I hope you can help me out:
1)
I have a normal ksh script and sometime I call awk command. I set some variables in the script and I would like to use them up within AWK as well. Unfortunately AWK seems to forget all the variable values outside of its own... (1 Reply)
Discussion started by: BearCheese
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a shell script with an ambedded awk script.
i need to pass a script variable to the awk script.
Please help.
Thanks in advance
Himani (3 Replies)
Discussion started by: HIMANI
3 Replies
5. Shell Programming and Scripting
Hello experts,
can I return a value from gawk to a shell script ?
My script as follows,
#Here I want the num value to shell script so that I can use later
gawk '
{
split($0,num,",");
print num
}'
gawk -v no=$number '{print no}'
file1
... (3 Replies)
Discussion started by: user_prady
3 Replies
6. Shell Programming and Scripting
Read parameter from a text file with one line which stored the date value like 20080831; below is the awk command I used
gawk -F, "{getline RunDate;print $RunDate" text file
When print $RunDate, it display 20080831
Would like to pass this variable to another script to use but not... (6 Replies)
Discussion started by: cbauw
6 Replies
7. Shell Programming and Scripting
I'm trying to store the response from a nawk command inside of a ksh script. The command is:
text=$(nawk -F: '$1 ~ /${imgArray}/ {print $2}' ${etcDir}/captions.txt)
From what I can tell, the imgArray variable is not being expanding when it is inside the single quote ('). Is there something I... (4 Replies)
Discussion started by: meman1188
4 Replies
8. UNIX for Dummies Questions & Answers
I know this topic has been dealt with previously, but the solutions I've seen don't work for me apparently.
I need to pass a variable defined in the shell to one in awk:
$ echo $var1
3
$ cat aaa
aaa 1
bbb 2
ccc 3
ddd 4
eee 5I've tried this, without success:
$ awk... (2 Replies)
Discussion started by: metaltree
2 Replies
9. Shell Programming and Scripting
Does anyone know of a way to do something similar to this with awk and kill? I want to create the variable in awk and pass that variable to kill.
ps -ef | grep -i chromium | awk '{$2=x}' | kill -9 $x 2>/dev/null (9 Replies)
Discussion started by: cokedude
9 Replies
10. UNIX for Dummies Questions & Answers
Hello,
May i please know how do i pass the shell variable to awk expression in the below script. It is returning null
#!/bin/bash
UNINUM=720922
UNINUM_DESC=`awk -F'|' -v UNINUM=$2 '/UNINUM/ {print $4}' datafile`
echo $UNINUM_DESC
datafile
4|First|720194|asdasdad
4|First|720735|asdasdsa... (8 Replies)
Discussion started by: Ariean
8 Replies
LEARN ABOUT PHP
collator_sort
COLLATOR_SORT(3) 1 COLLATOR_SORT(3)
Collator::sort - Sort array using specified collator
Object oriented style
SYNOPSIS
public bool Collator::sort (array &$arr, [int $sort_flag])
DESCRIPTION
Procedural style
bool collator_sort (Collator $coll, array &$arr, [int $sort_flag])
This function sorts an array according to current locale rules.
Equivalent to standard PHP sort(3) .
PARAMETERS
o $coll
-Collator object.
o $arr
- Array of strings to sort.
o $sort_flag
- Optional sorting type, one of the following:
o Collator::SORT_REGULAR - compare items normally (don't change types)
o Collator::SORT_NUMERIC - compare items numerically
o Collator::SORT_STRING - compare items as strings
Default sorting type is Collator::SORT_REGULAR. It is also used if an invalid $sort_flag value has been specified.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
collator_sort(3) example
<?php
$coll = collator_create( 'en_US' );
$arr = array( 'at', 'as', 'as' );
var_export( $arr );
collator_sort( $coll, $arr );
var_export( $arr );
?>
The above example will output:
array (
0 => 'at',
1 => 'as',
2 => 'as',
)array (
0 => 'as',
1 => 'as',
2 => 'at',
)
SEE ALSO
Collator constants, collator_asort(3), collator_sort_with_sort_keys(3).
PHP Documentation Group COLLATOR_SORT(3)