Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Please help me to write the shell script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Please help me to write the shell script
# 1  
Old 10-08-2015
Please help me to write the shell script
Please help me to write the shell script


Code:
AC|NAME|STATE|MAXVALUE|MINVALUE---------heading
111|UMA|ODISHA|123,00.00|54.00
111|UMA|ODISHA|124,00.00|25.00
111|UMA|ODISHA|114,00.00|58.00
111|UMA|ODISHA|104,00.00|00.00
111|UMA|ODISHA|194,00.00|19.00
111|UMA|ODISHA|184,00.00|64.00
112|DHAL|RKL|123,21.00|113.00
112|DHAL|RKL|231,29.00|143.00
112|DHAL|RKL|123,25.00|103.00
112|DHAL|RKL|123,13.00|133.00
112|DHAL|RKL|123,03.00|122.00
112|DHAL|RKL|313,9.00|11.00


Output should be display two record
Column max value and min value are different values so all the max value and min value will display parallel.

Code:
AC|NAME|STATE|                      MAXVALUE|                                                      MINVALUE
111|UMA|ODISHA|123,00.00|124,00.00|114,00.00|104,00.00|194,00.00|184,00.00    54.00|25.00|58.00|00.00|19.00|64.00
112|DHAL|RKL|123,21.00|231,29.00|123,25.00|123,13.00|123,03.00|313,9.00 113.00|143.00|103.00|133.00|122.00|11.00


Moderator's Comments:
Mod Comment Use code tags, thanks.
Last edited by zaxxon; 10-08-2015 at 03:28 PM..
# 2  
Old 10-08-2015
Please show what you have tried so far, thanks.
# 3  
Old 10-08-2015
Homework?
# 4  
Old 10-08-2015
new to shell script, so donot have any answer for this , i know we can achieve in database programming through litlagg

---------- Post updated at 02:52 PM ---------- Previous update was at 02:51 PM ----------

not home work i gave samle string as original string is big and wired
# 5  
Old 10-08-2015
This may come close to what you want, but in your sample the field separators between STATE and MAX differs from the one between MAX an MIN, which in turn is not consistent across records:
Code:
awk '
NR==1   {print
         next      
        }
        {IX=$1 FS $2 FS $3
         MAX[IX]=MAX[IX] DL[IX] $4
         MIN[IX]=MIN[IX] DL[IX] $5
         DL[IX]="|"
        }
END     {for (m in MAX) print m, MAX[m], MIN[m]}
' FS="|" file
AC|NAME|STATE|MAXVALUE|MINVALUE---------heading
111|UMA|ODISHA 123,00.00|124,00.00|114,00.00|104,00.00|194,00.00|184,00.00 54.00|25.00|58.00|00.00|19.00|64.00
112|DHAL|RKL 123,21.00|231,29.00|123,25.00|123,13.00|123,03.00|313,9.00 113.00|143.00|103.00|133.00|122.00|11.00

Last edited by RudiC; 10-09-2015 at 06:20 AM..
# 6  
Old 10-09-2015
Thanks RudiC for the help
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to write config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

2. UNIX for Dummies Questions & Answers

How to write Config shell script to pass variables in master shell script?

Dear Unix gurus, We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies

3. Shell Programming and Scripting

Need to write a shell script

Hi, I need to write a statement which will read a data from a specific line based on condition and then read related lines to delete. For example: |T20150322 100930290 208940000 598000080 700000000 930000202 100000000 .T56789 |T20150322 0100000000 0200000000 0500000000 9000000000... (1 Reply)
Discussion started by: abhi.mit32
1 Replies

4. Shell Programming and Scripting

Need to write a shell script

Hi, I need some help to write a script i need to write script that will count the no of logs generated for the day and specify the logfiles names which is not generated for the day. Default no of log generate per day is 29 if less than 29 logs generated it should specify the perticular logfile... (7 Replies)
Discussion started by: mail.chiranjit
7 Replies

5. Shell Programming and Scripting

Help shell script to write

Hi All, How to write a shell script 1. i have file name "/home/krupa"(krupa) 2. i have to wite a shell scripting , 3.script will not execute until reach "krupa" file in the location "/home/krupa"(krupa) and it will wait or go to sleep mode 3. if already "krupa" is there then execute the... (4 Replies)
Discussion started by: krupasindhu18
4 Replies

6. Shell Programming and Scripting

how to write shell script

Hi , i need to write a script like this In 1.sh ./test.sh wait(5sec) send ctrl+C to server ./testxxxx.sh first i need invoke test.sh from 1.sh , after wating for some time i need to close the test.sh script & i need to start new script i tried to invoke script... (2 Replies)
Discussion started by: pvr_satya
2 Replies

7. Shell Programming and Scripting

Need to Write Shell Script based off of this shell command

I'm trying to read a bunch of log files and output the lines that contain particular strings. To accomplish this, I've been running the following from the command line: find . -name "*" | xargs grep " " | grep " " > output.txt Two grep statements are needed in case I'm looking for a... (3 Replies)
Discussion started by: Rally_Point
3 Replies

8. Shell Programming and Scripting

I need to write a shell script.

Hi Guys, I need to write a shell script, to which I have getting results from CPU and Memory Utilization. This is to generate automatically through Shell script by running cron job. Is it possible to write it. I am new to this shell scripting. Can you please help me on this ASAP. ... (6 Replies)
Discussion started by: lakshmanrk
6 Replies

9. Shell Programming and Scripting

please Write a shell script

Hi Team, I am unable to write script. please guide me. My rquirement is as given below one file will have three columns with n number of rows like hostname port sid -------- ---- --- sun056 1527 PSP1 sun111 1529 PRP1 sun107 1580 PRD1 the script should... (6 Replies)
Discussion started by: rvrao77
6 Replies

10. Shell Programming and Scripting

need help to write shell script

. I wrote shell script with help to extract data and generate report . I need help to modify that in sub section . Currently I am generating the report in this format Version Name Host Total Number of Fails 10 Animator 45 10 Krachel ... (0 Replies)
Discussion started by: getdpg
0 Replies
Login or Register to Ask a Question