06-02-2010
Delete lines from file using Unix Script
Hi Experts,
I have a file in the below given format. First two lines are header and Trailer. Rest all are transaction Lines. I have to delete all other lines except first line (Header) and lines which contains 5000 in 1st column and 0 in 5th column.
Can anyone please kindly provide me with the script code. Thanks in Advance.
0000 00000 Header
0000 00000 Trailer
1000 00000 Others.
9999 00000
5000 09999 00000008499 0000999 0
5000 09999 00000008499 0000999 7
5000 09999 00000008499 0000999 0
5000 09999 00000008499 0000999 0
5000 09999 00000008499 0000999 7
4300 09999 00000008499 0000999 0
6000 09999 00000008499 0000999 0
1000 09999 00000008499 0000999 7
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to delete all the lines out a file from a unix script. Please help
Platform is Sun (3 Replies)
Discussion started by: alnita
3 Replies
2. Shell Programming and Scripting
Hi,
I am a newbie to shell scripting, and I have a file which quite large which I would like to delete lines at certain places. I want to search for a keyword which is recurring in the file. When matched I would like to delete the line. And when the file was so huge I thought I ought to learn... (3 Replies)
Discussion started by: mr_andrew
3 Replies
3. Shell Programming and Scripting
Hi All,
I have a file with 3 columns (Bank Name, Account Number and Amount). My requirement, I need to delete lines using Unix Shell script:
1. Which are having Alphanumeric characters in Account Number (eg. Line3).
2. Which are having 0.00 in amount. (eg. Line4)
3. And also I need to... (4 Replies)
Discussion started by: phani333
4 Replies
4. Shell Programming and Scripting
Hi Experts,
I have a file format as mentioned below. I would like to have unix script (HP Unix) which can:
1. Remove first 6 and last 3 lines.
2. Delete the lines where 3rd column having Alpha Numeric Number
3. Delete the lines where 4th column having 0.00
4. Calculate the sum of all the... (16 Replies)
Discussion started by: phani333
16 Replies
5. Shell Programming and Scripting
it will grep for a line and then delete these line. how do i begin to write this script if theres no available one? (3 Replies)
Discussion started by: garfish
3 Replies
6. Shell Programming and Scripting
File
6 dbnawldb010-b office Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/09/11 03:24:04
42 luigi-b IPNRemitDB Memphis_Corp_SQL_Diff Memphis-Corp-SQL-Inc-Application-Backup 03/10/11 00:41:36
6 ebs-sqldev1-b IPNTracking Memphis_Corp_SQL_Diff... (4 Replies)
Discussion started by: ajiwww
4 Replies
7. UNIX for Advanced & Expert Users
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
8. Shell Programming and Scripting
Hi
Iam having file like below
10.238.52.65 pun-ras-bng-mhs-01 server
10.238.52.65 pun-ras-bng-mhs-01 10.10.10.10
10.238.52.65 pun-ras-bng-mhs-01 10.10.20.10
10.238.54.1 enk-ras-bng-cse-01 server
10.238.54.1 enk-ras-bng-cse-01 10.10.30.10
10.238.54.1 enk-ras-bng-cse-01 10.10.10.10
... (5 Replies)
Discussion started by: surender reddy
5 Replies
9. Shell Programming and Scripting
Hi Guru's
The script has to read an entry from one file and delete the set of lines form other file. Below is the format of the file. In the below example, script should read the entries from input file 2 and delete the entries from input file 1.
Input file 1
cn: test@test1.com
abc:... (7 Replies)
Discussion started by: Samingla
7 Replies
10. UNIX for Advanced & Expert Users
Hi ,
i have a file with data as below.This is same file. But actual file contains to many rows.
i want to search for a string "Field 039 00" and delete that line and previous 3 lines in that file.. Can some body suggested me how can i do using either sed or awk command ?
Field 004... (7 Replies)
Discussion started by: vadlamudy
7 Replies
INPUT(5) File Formats Manual INPUT(5)
NAME
input - input data file format
DESCRIPTION
This manual page describes the output format of the file created by the Yagi-Uda project input or first programs. The file is an ASCII
file, so can be edited manually if required. It is read by yagi or optimise. The program optimise also creates the same file format.
NOTES
FREQUENCY
MIN_FREQUENCY
MAX_FREQUENCY
STEP_FREQUENCY
ELEMENTS
DRIVEN
PARASITIC
ANGULAR_STEP
DATA_DRIVEN
DATA_PARASITIC
The
#
is used as a comment.
A typical file, for an antenna designed for the 2m amateur band (144-146
MHz) might be as shown below. Note:
1) Reflector is at position 0.0
2) All elements lengths/positions are in m.
NOTES This line can be up to 400 characters.
FREQUENCY 145.000000
MIN_FREQUENCY 144.000000
MAX_FREQUENCY 146.000000
STEP_FREQUENCY 0.100000
ELEMENTS 10
DRIVEN 1
PARASITIC 9
ANGULAR_STEP 180.000000
#DATA_DRIVEN x y length diameter voltage phase
DATA_DRIVEN 0.30993 0.000000 1.002492 0.0063000000000000 1.000000 0.000000
# DATA_PARASITIC x y length diameter
DATA_PARASITIC
0.00000 0.00000 1.01902 0.00630
0.49859 0.00000 0.95551 0.00630
1.07338 0.00000 0.93595 0.00630
1.81020 0.00000 0.92050 0.00630
2.58152 0.00000 0.91322 0.00630
3.30390 0.00000 0.91243 0.00630
4.03692 0.00000 0.90423 0.00630
4.64108 0.00000 0.89081 0.00630
5.37418 0.00000 0.83912 0.00630
FILES
filename ASCII description of antenna. filename.out binary file
SEE ALSO
yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5).
AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov).
Yagi version 1.16 24th October 2000 INPUT(5)