Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Need to filter data from a file Post 302538426 by erora on Wednesday 13th of July 2011 02:14:53 AM
Old 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

filter data

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

Filter data from text file

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

Using input file to filter data from another file

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

extract data from a data matrix with filter criteria

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

Shell script to read lines in a text file and filter user data

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

filter last 24 hour data and put in new file

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

How to filter required data from file using bash script?

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

Filter a .kml file (xml) with data set from text file

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

How to filter out data file...?

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

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies
APT-SPY(8)						      System Manager's Manual							APT-SPY(8)

NAME
apt-spy - program to generate a /etc/apt/sources.list.d/apt-spy.list file SYNOPSIS
apt-spy -d distribution [ -a area ] [ -c config ] [ -e number ] [ -f file ] [ -i file ] [ -m mirror-list ] [ -o output-file ] [ -p proxy ] [ -s country-list ] [ -t time ] [ -u update-URL ] [ -w file ] [ -n number ] [ -h ] [ -v ] [ update ] DESCRIPTION
This manual page briefly documents the apt-spy command. apt-spy is a program that tests all of the Debian archive mirrors the user specifies for bandwith and writes, by default, to /etc/apt/sources.list.d/apt-spy.list the fastest server. The user can select which of the many Debian sites to benchmark by geographical location. apt-spy does not need to be run by root if the user provides a configuration file, a place where to store the mirror list and an output file. See examples for more details. OPTIONS
-d distribution Debian distribution to use. Sensible values would be `stable', `testing' or `unstable'. Distribution names can also be used. This value is directly used in the generated sources.list, and is required unless updating. -a area This will cause only servers in the specified area to be benchmarked. By default, valid values for area are `Africa', `Asia', `Europe', `North-America', `Oceania' and `South-America'. It is very easy to define your own areas or subset of servers to bench- mark. For further details see apt-spy.conf(5). -c config configuration file to use instead of /etc/apt-spy.conf. -e number `early finish'. Stop benchmarking after number of servers have been completed. Act as if all servers were benchmarked upon comple- tion. -f file file to grab from the Debian servers. By default apt-spy will test the servers by getting part of the `ls-lR' file in the base of the Debian tree on the mirror. This tells apt-spy to get file instead. It is assumed that this file is also relative to the Debian base directory. -i file use file as input for apt-spy. You should generate this input file using the -w option. -m mirror-list where to load the mirrors list from or where to save it to. The default location is /var/lib/apt-spy/mirrors.txt. Using this option allows you to specify a different location. When updating, this defines where the updated mirrors list will be saved. -o output-file location for the new sources.list. By default the new file is created as /etc/apt/sources.list. -p proxy use proxy as a proxy server. This should be specified as `hostname:port'. -s country-list A comma-separated list of countries to benchmark. At the moment, this cannot be used with the "area" option. -t time how long (approximately) in seconds to download for. By default time is 15 seconds. How long the benchmark actually downloads for varies due to the way libcurl works. With the default 15 seconds, the benchmark generally takes beween 10 and 25 seconds. Each server has potentially two protocols (ftp and http) so roughly one minute per server would be a reasonable estimate of how long it should take. Be aware that this does vary considerably, and that benchmarking any more than a very few servers takes considerable time (possibly several hours for `-a All'). -u update-URL specify custom URL to get an updated mirrors list from. This can be http, ftp, file, or any other URL type supported by libcurl. -w file write a number of top servers to file in a format suitable for use with the -i option. The number of servers to output can be speci- fied with the -n option, and defaults to 5. -n number the number of top servers to write with the -w option. update connect to http.us.debian.org and download the mirror list to /var/lib/apt-spy/mirrors.txt. The -u or -m options may be used to respectively specify a different URL for the mirrors list or a different location for the downloaded file. -v output a version number. -h print a short usage message. EXAMPLES
Non root usage: apt-spy -d stable -a Europe -m ./mirror.txt -o apt-spy.list -c apt-spy.conf Above command tests European mirrors for stable Debian release saving http://http.us.debian.org/debian/README.mirrors.txt into mirror.txt, writing source file into apt-spy.list using configuration from apt-spy.conf. Note that not root users need to specified all these parame- ters. Updating mirror list file: apt-spy update Creating the /etc/apt/sources.list.d/apt-spy.list file: apt-spy -d stable SEE ALSO
sources.list(5), apt-spy.conf(5), apt(8). AUTHOR
apt-spy and this manual page was written by Steven Holmes <steg@bsdeviant.org> and updated by Stefano Canepa <sc@linux.it>. The original version of apt-spy was written by Danny Rodriguez <messiah@optonline.net>. This version is a total rewrite. 17th December, 2011 APT-SPY(8)
All times are GMT -4. The time now is 04:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy