Sponsored Content
Top Forums UNIX for Dummies Questions & Answers How get only required lines & delete the rest of the lines in file Post 302426129 by reva on Tuesday 1st of June 2010 01:24:03 AM
Old 06-01-2010
Question How get only required lines & delete the rest of the lines in file

Hiiii
I have a file which contains huge data as
a.dat:
HTML Code:
 PDE 1990  1  9 18 51 28.90  24.7500   95.2800 118.0 6.1 0.0 BURMA
event name:     010990D
time shift:      7.3000
half duration:   5.0000
latitude:       24.4200
longitude:      94.9500
depth:         129.6000
Mrr:       2.016000e+25
Mtt:      -1.576000e+25
Mpp:      -4.390000e+24
Mrt:      -2.089000e+25
Mrp:      -1.011000e+25
Mtp:       1.012000e+25

 PDE 1990  1 10 11 53 21.20  11.6000   95.1900  33.0 5.3 5.4 ANDAMAN ISLANDS REGION
event name:     011090D
time shift:      1.6000
half duration:   2.5000
latitude:       11.7100
longitude:      95.0300
depth:          61.0000
Mrr:      -2.770000e+23
Mtt:      -2.288000e+24
Mpp:       2.565000e+24
Mrt:       6.300000e+22
Mrp:      -1.190000e+24
Mtp:       6.836000e+24

 PDE 1990  1 22 17 26 12.10   3.8500   96.1000  51.0 6.0 0.0 NORTHERN SUMATERA
event name:     012290D
time shift:      7.1000
half duration:   5.0000
latitude:        3.5500
longitude:      95.9300
depth:          50.1000
Mrr:       1.837000e+25
Mtt:      -1.010000e+25
Mpp:      -8.270000e+24
Mrt:       1.084000e+25
Mrp:      -1.030000e+25
Mtp:       1.330000e+25

 PDE 1990  2  5  5 16 45.10  37.0700   71.2700 102.0 6.1 0.0 AFGHANISTAN-USSR BORDER
event name:     020590A
time shift:      8.4000
half duration:   4.9000
latitude:       36.5600
longitude:      70.8400
depth:         113.5000
Mrr:       1.749000e+25
Mtt:      -2.940000e+25
Mpp:       1.191000e+25
Mrt:      -7.030000e+24
Mrp:      -1.093000e+25
Mtp:      -5.500000e+23
I just want to retain first line & delete rest of the lines in the file
THe output file should be like
b.dat
Code:
 PDE 1990  1  9 18 51 28.90  24.7500   95.2800 118.0 6.1 0.0 BURMA
 PDE 1990  1 10 11 53 21.20  11.6000   95.1900  33.0 5.3 5.4 ANDAMAN ISLANDS
 PDE 1990  1 22 17 26 12.10   3.8500   96.1000  51.0 6.0 0.0 NORTHERN SUMATERA
 PDE 1990  2  5  5 16 45.10  37.0700   71.2700 102.0 6.1 0.0 AFGHANISTAN-USSR BORDER

Help me out.....
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help required regarding Extracting lines from a file

I have a file containing the following contents All of us, including Zippy, our dog All of us, including Zippy and Zippy All of us, including Zippy and Zippy and Zelda Testing All of us Zippy Now, i wanna grep and get the lines which has only one occurance of word Zippy and starting with... (1 Reply)
Discussion started by: google_ever
1 Replies

2. Shell Programming and Scripting

SED: match pattern & delete matched lines

Hi all, I have the following data in a file x.csv: > ,this is some text here > ,,,,,,,,,,,,,,,,2006/11/16,0.23 > ,,,,,,,,,,,,,,,,2006/12/16,0.88 < ,,,,,,,,,,,,,,,,this shouldnt be deleted I need to use SED to match anything with a > in the line and delete that line, can someone help... (7 Replies)
Discussion started by: not4google
7 Replies

3. Shell Programming and Scripting

To extract the required lines from a file

I have a files in a directory in this format data data data ---BEGIN CERT----- data data data ---END CERT ----- Now, I want to extract the lines starting from --BEGIN CERT-- and write the contents till the end of file into a new file.How can I do this for all the files in the... (1 Reply)
Discussion started by: sureshg
1 Replies

4. Shell Programming and Scripting

How to delete lines in a file that have duplicates or derive the lines that aper once

Input: a b b c d d I need: a c I know how to get this (the lines that have duplicates) : b d sort file | uniq -d But i need opossite of this. I have searched the forum and other places as well, but have found solution for everything except this variant of the problem. (3 Replies)
Discussion started by: necroman08
3 Replies

5. UNIX for Advanced & Expert Users

In a huge file, Delete duplicate lines leaving unique lines

Hi All, I have a very huge file (4GB) which has duplicate lines. I want to delete duplicate lines leaving unique lines. Sort, uniq, awk '!x++' are not working as its running out of buffer space. I dont know if this works : I want to read each line of the File in a For Loop, and want to... (16 Replies)
Discussion started by: krishnix
16 Replies

6. Shell Programming and Scripting

search and replace, when found, delete multiple lines, add new set of lines?

hey guys, I tried searching but most 'search and replace' questions are related to one liners. Say I have a file to be replaced that has the following: $ cat testing.txt TESTING AAA BBB CCC DDD EEE FFF GGG HHH ENDTESTING This is the input file: (3 Replies)
Discussion started by: DeuceLee
3 Replies

7. Shell Programming and Scripting

Sed/awk to delete single lines that aren't touching other lines

Hello, I'm trying to figure out how to use sed or awk to delete single lines in a file. By single, I mean lines that are not touching any other lines (just one line with white space above and below). Example: one two three four five six seven eight I want it to look like: (6 Replies)
Discussion started by: slimjbe
6 Replies

8. Shell Programming and Scripting

Delete 40 lines after every 24 lines from a file

Hello, I have file of more than 10000 lines. I want to delete 40 lines after every 20 lines. e.g from a huge file, i want to delete line no from 34 - 74, then 94 - 134 etc and so on. Please let me know how i can do it. Best regards, (11 Replies)
Discussion started by: nehashine
11 Replies

9. Shell Programming and Scripting

sed one liner to Delete blank lines - Help required

Hi, cat test.txt BlankLine BlankLine BlankLine BlankLine ello hi helo BlankLine BlankLine heylo BlankLine BlankLine BlankLine done BlankLine BlankLine BlankLine (1 Reply)
Discussion started by: TomG
1 Replies

10. UNIX for Beginners Questions & Answers

How to search & delete inclusively between two lines?

Hi all, I was wondering if anyone would know how to search & delete inclusively between two lines, please: Important: There are multiple }; lines. I'm curious how to delete the correct one only. Line numbers may vary each time this script is run. For example, I'd like to delete only the... (6 Replies)
Discussion started by: chatguy
6 Replies
LLSEARCH(1)						      General Commands Manual						       LLSEARCH(1)

NAME
llsearch - Search a GNIS file for place names within a given block of latitude/longitude SYNOPSIS
llsearch [-L] | [latitude_low longitude_low latitude_high longitude_high] DESCRIPTION
The U.S. Geological Survey supports sites on the Internet with Geographic Names Information System (GNIS) files. These files contain lists of place names, complete with their latitude/longitude and other information. There are separate files for each of the U.S. states, and each file contains many, many, many place names. If you want to use this data with drawmap, it is useful to reduce the data to only the items that you need. Llsearch lets you filter a GNIS file and winnow out only those place names that fall within the latitude/longitude boundaries that you specify. (You may want to specify boundaries that are a tiny bit larger than what you are interested in, so that numerical quantization doesn't eliminate locales that fall exactly on your boundaries.) Latitudes and longitudes are positive for north latitude and east longitude, and negative for south latitude and west longitude. Llsearch expects you to enter them in decimal degrees. (The latitudes and longitudes in the GNIS file are in degrees-minutes-seconds format, fol- lowed by 'N', 'S', 'E', or 'W'. However, there are two available file formats, and one of the formats also contains the latitudes/longi- tudes in decimal degrees.) Typical usage is as follows: gunzip -c california.gz | llsearch 33 -118 34 -117 > gnis_santa_ana_west If you enter the "-L" option, the program will print some license information and exit. Once you have reduced the data to some subset of interest, you can search for particular items via the grep or perl commands, or other search commands, or you can simply edit the results with your favorite text editor. Search commands are useful in reducing the sheer vol- ume of data to a more manageable size (by extracting, say, all mountain summits or all streams), but you will probably ultimately end up looking through the remaining data manually. The individual records contain codes, such as "ppl" for populated places, and "summit" for mountain tops, that can help you pick and choose. There is considerable redundancy in place names, and human intelligence is useful in sorting things out. While I was writing drawmap and llsearch, I frequently gazed out my office window, where I could spot at least two, and possibly three Baldy Mountains. There are also quite a few Beaver Creeks, Bear Canyons, Saddle Buttes, and Springfields out there. By taking a close look at the information associated with each place name, you can find the particular locations that interest you. SEE ALSO
drawmap(1) Jul 24, 2001 LLSEARCH(1)
All times are GMT -4. The time now is 01:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy