07-13-2011
Need to filter data from a file
Hi,
I have a file with hundreds of records.
There are four fields on each line, separated by semicolons.
Name
Height (meters)
Country
Continent (Africa,Asia,Europe,North America,Oceania,South
America,The Poles)
I need to Write the command to find display how many mountains appear in
the list on each continent , like this:
30 Africa
144 Asia
91 Europe
163 North America
11 Oceania
116 South America
3 The Poles
I know I can count it by using Grep and filters but I will need one command per continent. How do I use a single command to list down the output in this format?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I have two files and their names are donotcall.txt, filter_it.txt. I want output.txt file with all data that is in filter_it.txt file but not in donotcall.txt. Can anybody help me to write 1-2 lines unix code for this.
donotcall.txt contains following data. Each row represent phone... (3 Replies)
Discussion started by: deep.singh
3 Replies
2. Windows & DOS: Issues & Discussions
Hi All
We have got a text file, which has data dumped from 60 tables.
From these 60 tables of data we need data from 4 tables only.
I tried assigning line numbers to filter out data, but it is not working as intended.
below is the sample file
----Table1-----
3,dfs,43,df
4,sd,5,edd... (18 Replies)
Discussion started by: b_sri
18 Replies
3. UNIX for Dummies Questions & Answers
I have a data file:
abc Text Text Text Unique Text
123 Text word Line Unique Text
fgh Text data Line Unique Text
789 Text Text Line Unique Text
543 Text Text Data Unique Text
and a filter file
123
789
I want to extract out from the data file the two records that contain the keys... (1 Reply)
Discussion started by: tumblez
1 Replies
4. Shell Programming and Scripting
Here is what old matrix look like,
IDs X1 X2 Y1 Y2
10914061 -0.364613333 -0.362922333 0.001691 -0.450094667
10855062 0.845956333 0.860396667 0.014440333 1.483899333... (7 Replies)
Discussion started by: ssshen
7 Replies
5. Shell Programming and Scripting
hi all,
I have this file with some user data.
example:
$cat myfile.txt
FName|LName|Gender|Company|Branch|Bday|Salary|Age
aaaa|bbbb|male|cccc|dddd|19900814|15000|20|
eeee|asdg|male|gggg|ksgu|19911216|||
aara|bdbm|male|kkkk|acke|19931018||23|
asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies
6. UNIX for Advanced & Expert Users
i have file server 1 (filesvr01acess.log) and disc server 1 (discsvr01acess.log) in unix box(say ip adress of the box 10.39.66.81)
Similiarly i have file server 2 (filesvr01acess.log) and disc server 2(discsvr01acess.log) in another unix box(say ip adress of the box 10.39.66.82).
Now my... (1 Reply)
Discussion started by: nripa1
1 Replies
7. Shell Programming and Scripting
Hi All ,
I have one file like below ,
Owner name = abu2-kxy-m29.hegen.app
Item_id = AX1981, special_id = *NULL*, version = 1
Created = 09/01/2010 12:56:56 (1283389016)
Enddate = 03/31/2011 00:00:00 (1301554800)
From the above file I need to get the output in the below format ,i need... (3 Replies)
Discussion started by: gnanasekar_beem
3 Replies
8. Shell Programming and Scripting
I have a .kml file. So I want filter the .kml to get only the tags that have this numeric codes that they are in a text file
11951
11952
74014
11964
11965
11969
11970
11971
11972
60149
74018
74023
86378
11976
11980
11983
11984
11987 (5 Replies)
Discussion started by: pcoj33
5 Replies
9. Shell Programming and Scripting
Hi...
I would like to filter out my data file....in two different way
1st way is like this, I will take one example..here...
The script should ask like this.
Enter min value in first column
Enter max value in first column
Enter min value in second column
Enter max value in... (5 Replies)
Discussion started by: nex_asp
5 Replies
10. UNIX for Dummies Questions & Answers
sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies
LEARN ABOUT PHP
datetimezone
DATETIMEZONE(3) 1 DATETIMEZONE(3)
The DateTimeZone class
INTRODUCTION
Representation of time zone.
CLASS SYNOPSIS
DateTimeZone
DateTimeZone
Constants
o const integer$DateTimeZone::AFRICA1
o const integer$DateTimeZone::AMERICA2
o const integer$DateTimeZone::ANTARCTICA4
o const integer$DateTimeZone::ARCTIC8
o const integer$DateTimeZone::ASIA16
o const integer$DateTimeZone::ATLANTIC32
o const integer$DateTimeZone::AUSTRALIA64
o const integer$DateTimeZone::EUROPE128
o const integer$DateTimeZone::INDIAN256
o const integer$DateTimeZone::PACIFIC512
o const integer$DateTimeZone::UTC1024
o const integer$DateTimeZone::ALL2047
o const integer$DateTimeZone::ALL_WITH_BC4095
o const integer$DateTimeZone::PER_COUNTRY4096
Methods
o public DateTimeZone::__construct (string $timezone)
o public array DateTimeZone::getLocation (void )
o public string DateTimeZone::getName (void )
o public int DateTimeZone::getOffset (DateTime $datetime)
o public array DateTimeZone::getTransitions ([int $timestamp_begin], [int $timestamp_end])
o publicstatic array DateTimeZone::listAbbreviations (void )
o publicstatic array DateTimeZone::listIdentifiers NULL ([int $what = DateTimeZone::ALL], [string $country])
PREDEFINED CONSTANTS
o DateTimeZone::AFRICA -Africa time zones.
o DateTimeZone::AMERICA -America time zones.
o DateTimeZone::ANTARCTICA -Antarctica time zones.
o DateTimeZone::ARCTIC -Arctic time zones.
o DateTimeZone::ASIA -Asia time zones.
o DateTimeZone::ATLANTIC -Atlantic time zones.
o DateTimeZone::AUSTRALIA -Australia time zones.
o DateTimeZone::EUROPE -Europe time zones.
o DateTimeZone::INDIAN -Indian time zones.
o DateTimeZone::PACIFIC -Pacific time zones.
o DateTimeZone::UTC -UTC time zones.
o DateTimeZone::ALL -All time zones.
o DateTimeZone::ALL_WITH_BC -All time zones including backwards compatible.
o DateTimeZone::PER_COUNTRY -Time zones per country.
PHP Documentation Group DATETIMEZONE(3)