I think one of main misunderstandings in the approach above is the fact that it doesn't know the address in the associative array. So I am reversing now the input files, combining the best of all worlds and voila
might be a solution. Haven't tested it extensively so far, so be careful.
ex:
a file has :
122323
123456456
125656879
678989965t635
234323432
b has :
this is finance no.
this is phone no
this is extn
ajkdgag
idjsidj
i want the o/p as:
122323 his is finance no.
123456456 this is phone no
123456456 ... (4 Replies)
Hi,
I have a query about joining files using data ranges.
Example files below - I want to join file1 to file2 with matches where file1 column 1 is equal to file2 column1, and file1 column 2 is within the range of file2 columns 3 and 4. I would like rows which don't match to be printed too.
... (4 Replies)
Hi,
I have the following input file
32895901-d17f-414c-ac93-3e7e0f5ec240 AND @GDF_INPUT
73b129e1-1fa9-4c0d-b95b-4682e5389612 AUS @GDF_INPUT
40f82e88-d1ff-4ce2-9b8e-d827ddb39447 BEL @GDF_INPUT
36e9c3f1-042a-43a4-a80e-4a3bc2513d01 BGR @GDF_INPUT
I want to split column 3 into two columns:... (1 Reply)
Hi all,
I have 2 files
one file contain data like this in one column
AST3
GSTY4
JST3
second file containign data like this in 2 columns
AST3(PAXXX),GSTY4(PAXXY) it is used in diabetes
KST4 it is used in blood... (6 Replies)
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 Replies)
I have the need to match the first two columns and when they match, calculate the percent of average for the third columns. The following awk script does not give me the expected results.
awk 'NR==FNR {T=$3; next} $1,$2 in T {P=T/$3*100; printf "%s %s %.0f\n", $1, $2, (P>=0)?P:-P}' diff.file... (1 Reply)
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT PHP
geoip_region_by_name
GEOIP_REGION_BY_NAME(3) 1 GEOIP_REGION_BY_NAME(3)geoip_region_by_name - Get the country code and regionSYNOPSIS
array geoip_region_by_name (string $hostname)
DESCRIPTION
The geoip_region_by_name(3) function will return the country and region corresponding to a hostname or an IP address.
This function is currently only available to users who have bought a commercial GeoIP Region Edition. A warning will be issued if the
proper database cannot be located.
The names of the different keys of the returning associative array are as follows:
o "country_code" -- Two letter country code (see geoip_country_code_by_name(3))
o "region" -- The region code (ex: CA for California)
PARAMETERS
o $hostname
- The hostname or IP address whose region is to be looked-up.
RETURN VALUES
Returns the associative array on success, or FALSE if the address cannot be found in the database.
EXAMPLES
Example #1
A geoip_region_by_name(3) example
This will print the array containing the country code and region of the host example.com.
<?php
$region = geoip_region_by_name('www.example.com');
if ($region) {
print_r($region);
}
?>
The above example will output:
Array
(
[country_code] => US
[region] => CA
)
PHP Documentation Group GEOIP_REGION_BY_NAME(3)