Hi,
I have 7 big flat files, each contains 24 million records which have been sorted by the first field delimitered by Ctrl B (002).
I want to join them together side by side, eg.
File A:
1^Ba^Bb
2^Bx^By
....
File B:
1^Bc^Bd
2^Bm^Bn
....
After merged, it should look like :... (7 Replies)
I need a perl script which will create an output file after comparing two diff file in a directory path:
/export/home/abc/file1
/export/home/abc/file2
File Format: <IP>TAB<DeviceName><TAB>DESCRIPTIONS
file1:
10.1.2.1.3<tab>abc123def<tab>xyz.mm1.ppp.... (2 Replies)
Hi,
I have two text files.The first and the 2nd file have data in the same format
For e.g. The first file has
table_name1 column1 sum(column1) max(column1) min(column1)
table_name1 column2 sum(column2) max(column2) min(column2)
table_name1 coulmn3 sum(column3) max(column3) min(column3)
... (13 Replies)
Hi,
I have been thinking of how to script this but i have no clue at all..
Could someone please help me out or give me some idea on this?
I would like to group those lines with the same first variable in each line, joining the 2nd variables with commas.
Let's say i have the following input.
... (3 Replies)
Hi all.
This is my first post on this forum. I've previously found great help in the huge knowledgebase that is here, but this time I have not been able to find a solution to my problem.
I have a large text file that looks like this:
typedef struct ABC_struct_nbr1_ {
char attr1; /*... (0 Replies)
I am trying to Join all the lines matching similar pattern.
Example ;
I wanted to join all the lines which has sam to a single line.
In next line, i wanted to have all the lines with jones to a single line....etc
> cat sample.txt
sam 2012/11/23
sam 2012/12/5
sam 2012/12/5
jones... (2 Replies)
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
Thanks in advance for your help.
File A
A,B,C,45,46... (2 Replies)
Dear folks
Hello
I have a one file called (file1) which the structure looks like this
1 gi|358484521|ref|NW_003764373.1|
1 gi|358484520|ref|NW_003764374.1|
1 gi|358484519|ref|NW_003764375.1|
.
.
.
30 gi|368484519|ref|NW_00449375.1|
In addition, I have around 300... (19 Replies)
I have two directories called English and Hindi. Each directory contains the same number of files with the only difference being that in the case of the English Directory the tag is
.english
and in the Hindi one the tag is
.Hindi
The file may contain either a single text or more than one text... (7 Replies)
Hi,
I want to compare same column in two files, if values match then display the column or display "NA".
Ex :
File 1 :
123
abc
xyz
pqr
File 2:
122
aab
fdf
pqr
fff
qqq
rrr (1 Reply)
Discussion started by: hkoshekay
1 Replies
LEARN ABOUT DEBIAN
geoip
geoip(3) Version 0.2 geoip(3)NAME
geoip - A Tcl extension for geographic or organisational lookup of IP addresses and hostnames.
SYNOPSIS
geoip open [-type TYPE ] [-flags FLAG ]
geoip open [-file PATH ] [-flags FLAG ]
geoip [COMMAND]
geoip [QUERY] arg1
DESCRIPTION
This Tcl extension encapsulates most of GeoIP C API functions into tcl commands.
OPEN OPTIONS
open takes either a file path and a set of flags, or a type and a set of flags. Supported types and flags are described below.
TYPE Looks under the standard installation share directory, eg /usr/local/share/GeoIP/ for a GeoIP database according to type.
PATH Absolute/relative path to GeoIP database.
FLAG Flags seperated by ':', eg memory_cache:memory_check
COMMAND
Individual singular commands can be one of:
close Close the currently open database.
db_info
Get information about the current database.
db_edition
Returns edition of opened database.
db_avail
Test the availability of databases in your system in known locations. e.g db_avail country_edition
QUERY
Commands that query the database. All commands return N/A if a result cannot be found. If none already open, a command will attempt to open
a suitable database. country commands will open a country_edition database. region commands will open a region_edition_rev1 one. name com-
mands will open an org_edition one, and the record_edition will open a city_edition_rev1 database. The commands are:
country_code_by_addr
Takes an IP address and returns the ISO-3166-1 Alpha-2 code of the country.
country_code3_by_addr
Takes an IP address and returns the ISO-3166-1 Alpha-3 code the country.
country_code_by_name
Takes a hostname and returns the ISO-3166-1 Alpha-2 code the country.
country_code3_by_name
Takes a hostname and returns the ISO-3166-1 Alpha-3 code the country.
country_name_by_addr
Takes an IP address and returns the country name.
country_name_by_name
Takes a hostname and returns the country name.
name_by_addr
Takes an IP address and returns the organisation name (or ISP/ASnum according to the opened database)
name_by_name
Takes a hostname and returns the organisation name.
region_by_addr
Takes an IP address and returns these region attributes as in an associative array: country, region
region_by_name
Takes a hostname and returns the region attributes.
record_by_addr
Takes an IP address and returns these record attributes as in an associative array: code, code3, region, country, city, postcode,
latitude, longitude, dma(dma code), and area (area code)
record_by_name
Takes a hostname and returns the record attributes.
TYPES
Relevant types of databases are: country_edition, org_edition, isp_edition, city_edition_rev1, region_edition_rev1, geoip_asnum_edition.
"open -type" will accept their unambiguous abbreviations.
FLAGS
Valid flags are: standard, memory_cache, check_cache, index_cache.
FILES
./share/GeoIP.dat
GeoIP country_edition database.
./share/GeoIPOrg.dat
GeoIP org_edition database.
./share/GeoIPCity.dat
GeoIP region_city_rev1 database.
./share/GeoIPRegion.dat
GeoIP region_edition_rev1 database.
./share/GeoIPASNum.dat
GeoIP asnum_edition database.
BUGS
Please report to author.
AUTHOR
Djihed Afifi <djihed@gmail.com>.
SEE ALSO
GeoIP C API documentation <www.maxmind.com>
Tcl extension April 2007 geoip(3)