09-12-2008
shell script to process file line by line
Hi ,
I am new to shell scripting (ksh shell) and trying to accomplish few requiremtns.
I have a file with the following format
EMP NO EMP NAME AGE Amt Paid
12 Mark Taylor 32 32333
14 James Brown Smith 23 23232
12 Mark Taylor 32 42333
13 Lary King 56 154545
15 Stevert Clark 34 34434
14 James Smith 23 23232
The script should be able to process the lines , find the lines which are similar excepting the amt paid and merge the similar lines and add the amt paid.
The expected result after running the script should look like this
12 Mark Taylor 32 47666
14 James Brown Smith 23 46464
13 Lary King II 56 154545
15 Stevert Clark 34 34434
As you can see the employee 12 and 14 got updated amt and the redundent lines removed.
Please guide onthe same.
Thanks,
RS.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have gps receiver log..its giving readings .like below
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
GPSD,R=1
$GPGSV,3,1,11,08,16,328,40,11,36,127,00,28,33,283,39,20,11,165,00*71... (3 Replies)
Discussion started by: gudivada213
3 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I need to read a text file from shell script line by line and copy the feilds of each line.
Below is the complete requirement.
I've text file which contains ...
pgm1 file11 file12 file13
pgm2 file21 file22
pgm3 file31 file32 file33
I'll give input as... (4 Replies)
Discussion started by: ani12345
4 Replies
3. Shell Programming and Scripting
hello ,
plz help for below script req:-
how can we read a file line by line in shell script ? (4 Replies)
Discussion started by: abhigrkist
4 Replies
4. Shell Programming and Scripting
FOLKS ,
i have a text file that is generated automatically of an another korn shell script, i want to bring in the fifth line of the text file in to my korn shell script and look for a particular word in the line . Can you all share some thoughts on this one.
thanks...
Venu (3 Replies)
Discussion started by: venu
3 Replies
5. Shell Programming and Scripting
Hi ,
I am trying to write an shell, which reads a text file (from a location) having a list of numbers of strictly 5 digits only ex: 33144
Now my script will check :
1) that each entry is only 5 digits & numeric only, no alphabets, & its not empty.
2)then it executes a shell script called... (8 Replies)
Discussion started by: new_to_shell
8 Replies
6. Shell Programming and Scripting
Hi all
I have spent half a day trying to create a shell script which reads a configuration file on a line by line basis.
The idea of the file is that each will contain server information, such as IP address and various port numbers. The line could also be blank (The file is user created). Here... (1 Reply)
Discussion started by: haggismn
1 Replies
7. Shell Programming and Scripting
I have a LOG file which looks like this
Import started at: Mon Jul 23 02:13:01 EDT 2012
Initialization completed in 2.146 seconds.
--------------------------------------------------------------------------------
--
Import summary for Import item: PolicyInformation... (8 Replies)
Discussion started by: biztank
8 Replies
8. Shell Programming and Scripting
hello
i want to access line by line from a file and print that line every time can i have a shell script for doing this
thanks (4 Replies)
Discussion started by: ramreddy502
4 Replies
9. Shell Programming and Scripting
Hi All,
Am trying to write wrapper shell/bash script on a utility tool for which i need to pass 2 files as arugment to execute utility tool.
Wraper script am trying is to do with above metion 2 files.
utility tool accepts :
a. userinfo file : which contains username
b. item file : which... (2 Replies)
Discussion started by: Optimus81
2 Replies
10. Shell Programming and Scripting
i have a text file as belows, it includes 2 columns, 1st is the column name, 2nd is the file_name
data_file.txt
column_name file_name
col1 file1
col2 file2
col3 file1
col4 file1
col5 file2
now, i would like to... (4 Replies)
Discussion started by: tester111
4 Replies
LEARN ABOUT OPENSOLARIS
amt
amt(1) User Commands amt(1)
NAME
amt - run abstract machine test
SYNOPSIS
amt [-s]
DESCRIPTION
The amt command is for use in a Common Criteria security certified system. The command is used to verify that the low level functions nec-
essary to enforce the object reuse requirements of the Controlled Access Protection Profile are working correctly. /usr/bin/amt is a shell
script that executes tests specific to your system. For a 32-bit system, the tests run as a 32-bit application. For a 64-bit system, the
tests run twice; once as a 32-bit application and once as a 64-bit application.
amt lists test results with a pass or fail for each test it performs, unless output is suppressed with the -s option.
OPTIONS
The following option is supported:
-s Suppresses output.
EXIT STATUS
The following error values are returned:
0 All tests passed.
>0 Count of the number of tests that failed.
<0 Incorrect command line argument.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|Interface Stability |Committed |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
SunOS 5.11 19 Aug 2003 amt(1)