I've tried your script, the expected number of missing values in real file are 78 but is printing 108 numbers.
Is there a way to compare column 1 with a preloaded array that contains elements from 1 to N? in order to print values of array that are not present in column1?
Here is what I am trying to do:
I have a list of numbers that I pulled from an awk command in a column like so:
1
3
4
7
8
I want to find which numbers in the list are missing out of a range. So let's say I want to find out from the list above which numbers are missing from the... (6 Replies)
Hi all,
I have a large column of numbers like
5.6789
2.4578
9.4678
13.5673
1.6589
.....
I am trying to make an awk code so that awk can easily go through the column and arrange the numbers from least to highest like
1.6589
2.4578
5.6789
.......
can anybody suggest, how can I do... (5 Replies)
Hi Guys,
I'm trying to clean up my home logger file and can't seem to work this out.
Here is my data:
10-19-2009 08:39 00.2 00.0 00.7 01.1 49.1 0.0 11.9 270.1 -49.1 220.9
10-19-2009 08:40 00.2 00.0 00.7 00.7 49.1 0.0 171.9 171.9 49.1 220.9
10-19-2009 08:41 00.1 00.0 00.7 00.8 24.5 0.0... (2 Replies)
Hi Experts,
The content of the raw file:
date,nomsgsent,nomsgnotdeliver,nomsgdelay
201003251000,1000,1,2
201003251000,900,0,0
201003251000,1450,0,0
201003251000,1230,0,0
However, sometimes, the column will missing in the raw files:
e.g.
date,nomsgsent,nomsgdelay... (8 Replies)
Hi All,
I have 100 files with names like this:
1.dat, 2.dat, 3.dat until 100.dat.
My dat files look like this:
42323 0
438939 1
434 0
0.9383
3434
120.23 3
234
As you can see in the second column, some numbers are missing. I want to fill those missing places with 0's in all... (3 Replies)
Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7... (3 Replies)
Hi all,
I have two (2) sets of files that are based on some snapshots of database that I want to merge and insert any missing sequential number.
Below are example representation of these files:
file1:
DATE TIME COL1 COL2 COL3 COL4 ID
01/10/2013 0800 100 ... (3 Replies)
Dear all,
I am kindly seeking assistance on the following issue.
I am working with data that is sampled every 0.05 hours (that is 3 minutes intervals) here is a sample data from the file
5.00000 15.5030
5.05000 15.6680
5.10000 16.0100
5.15000 16.3450
5.20000 16.7120
5.25000... (4 Replies)
Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2
Scenario 1
i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of... (1 Reply)
Discussion started by: as7951
1 Replies
LEARN ABOUT PHP
array_intersect_assoc
ARRAY_INTERSECT_ASSOC(3) 1 ARRAY_INTERSECT_ASSOC(3)array_intersect_assoc - Computes the intersection of arrays with additional index checkSYNOPSIS
array array_intersect_assoc (array $array1, array $array2, [array $...])
DESCRIPTION array_intersect_assoc(3) returns an array containing all the values of $array1 that are present in all the arguments. Note that the keys
are used in the comparison unlike in array_intersect(3).
PARAMETERS
o $array1
- The array with master values to check.
o $array2
- An array to compare values against.
o $...
- A variable list of arrays to compare.
RETURN VALUES
Returns an associative array containing all the values in $array1 that are present in all of the arguments.
EXAMPLES
Example #1
array_intersect_assoc(3) example
<?php
$array1 = array("a" => "green", "b" => "brown", "c" => "blue", "red");
$array2 = array("a" => "green", "b" => "yellow", "blue", "red");
$result_array = array_intersect_assoc($array1, $array2);
print_r($result_array);
?>
The above example will output:
Array
(
[a] => green
)
In our example you see that only the pair "a" => "green" is present in both arrays and thus is returned. The value "red" is not returned
because in $array1 its key is 0 while the key of "red" in $array2 is 1, and the key "b" is not returned because its values are different in
each array.
The two values from the key => value pairs are considered equal only if (string) $elem1 === (string) $elem2 . In other words a strict type
check is executed so the string representation must be the same.
SEE ALSO array_intersect(3), array_uintersect_assoc(3), array_intersect_uassoc(3), array_uintersect_uassoc(3), array_diff(3), array_diff_assoc(3).
PHP Documentation Group ARRAY_INTERSECT_ASSOC(3)