Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell/Perl logic for loop
Top Forums Shell Programming and Scripting Shell/Perl logic for loop Post 302639099 by preethgideon on Friday 11th of May 2012 08:03:21 AM
Old 05-11-2012
Shell/Perl logic for loop
Hi,
I have a requirement as follows. Have 3 files. Need to match up the data in each one of them and sum up the data by a field and display it. example given below.

File 1 : Name, Emp id
File 2 : Empid, Subject,
File 3 : Subject, Score, Class

Match Emp id in File 1 and File 2 and then match up Subject from File 2 and File 3 and print the results.

O/p 1 - Name, Emp id, Subject , Score, Class.

Now group the details by the Empid and print the data. One added feature needed is the score can be negative. So if we could print the +ve and -ve seperately at Emp id is betetr.

Currently I am using a combination of Shell, Database join and macro to do this wrork. Want to eliminate the DB and macro. Please assist.

PS: This is NOT an assignment.

Thanks and Regards,
Gideon.
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell or PERL Logic

Hello All, Currently i am working on a logic in PERL scripting ... But i am sort of stuck up, can any one please help. Here goes. 1. Search for a pattern in a file 2. If the pattern matched lets say 10 lines 2.1 Reterive the first line and check for another pattern 2.1.1 if... (1 Reply)
Discussion started by: maxmave
1 Replies

2. Shell Programming and Scripting

While Loop Logic

I would need to with making while loop logic working in shell program when I am new into the shell programing 1) I would need to try to get the file from the remote side ----need to try 15 mins apart for 4 times and terminate the program if file is not available.... I would need to know how I... (4 Replies)
Discussion started by: sambakamba
4 Replies

3. Shell Programming and Scripting

for loop logic with multiple parameters

hi, unix wizards, i have a question about the logic of my inner for loop below. first, what i am trying to do is to write a script called create_account that automatically creates mysql accounts. the user can provide a user_name or a group_id as an argument (and the script can take multiple... (1 Reply)
Discussion started by: ankimo
1 Replies

4. Shell Programming and Scripting

loop logic inside of an inline redirect?

i need to log the feedback from the ftp server as i'm performing some deletes. the only way i know of to do this is with the inline redirect << EOF ... but from there to the closing EOF, it's like i'm at the ftp command prompt, so I don't know how to have ksh script logic in there I have an... (3 Replies)
Discussion started by: tlavoie
3 Replies

5. Shell Programming and Scripting

Perl - pass shell-vars into perl for input loop

I need to process a file line-by-line using some value from a shell variable Something like:perl -p -e 's/$shell_srch/$shell_replace/g' input.txt I can't make the '-s' work in the '-p' or '-n' input loop (or couldn't find a syntaxis.) I have searched and found... (4 Replies)
Discussion started by: alex_5161
4 Replies

6. UNIX for Dummies Questions & Answers

if then else logic with while loop problem

Hi Friends, I have to do write a shell file based on one flag.If that flag value is 'N' then process look in $DATA are and the normal process continue.If vaule is 'P' then it check for the files in different location $CONV and move those file in $DATA area and rest of the process... (2 Replies)
Discussion started by: Param0073
2 Replies

7. Shell Programming and Scripting

while loop logic

Hi, Here I am trying to query database and check a value, if the value not matches then I wants to re-query the database.Once the value matches, I want to email the reqidstatus_log.txt file. Database query produces a file reqidstatus_log.txt which contains result. But the query not working as... (3 Replies)
Discussion started by: rajsp217
3 Replies

8. Shell Programming and Scripting

Shell or Perl Loop Screenshot URLs

I am trying to capture screenshots from a huge list of URLs. I am able to manually capture images of individual pages; that is, I simply run the following command to get a screenshot of Foo.com $ python /path/to/screencapture.sh http://www.foo.com I want to modify the script so that instead of... (2 Replies)
Discussion started by: chipperuga
2 Replies

LEARN ABOUT DEBIAN

file::homedir::unix

File::HomeDir::Unix(3pm)				User Contributed Perl Documentation				  File::HomeDir::Unix(3pm)

NAME

       File::HomeDir::Unix - Find your home and other directories on legacy Unix

SYNOPSIS

	 use File::HomeDir;

	 # Find directories for the current user
	 $home	  = File::HomeDir->my_home;	   # /home/mylogin
	 $desktop = File::HomeDir->my_desktop;	   # All of these will...
	 $docs	  = File::HomeDir->my_documents;   # ...default to home...
	 $music   = File::HomeDir->my_music;	   # ...directory
	 $pics	  = File::HomeDir->my_pictures;    #
	 $videos  = File::HomeDir->my_videos;	   #
	 $data	  = File::HomeDir->my_data;	   #

DESCRIPTION

       This module provides implementations for determining common user directories.  In normal usage this module will always be used via
       File::HomeDir.

SUPPORT

       See the support section the main File::HomeDir module.

AUTHORS

       Adam Kennedy <adamk@cpan.org>

       Sean M. Burke <sburke@cpan.org>

SEE ALSO

       File::HomeDir, File::HomeDir::Win32 (legacy)

COPYRIGHT

       Copyright 2005 - 2011 Adam Kennedy.

       Some parts copyright 2000 Sean M. Burke.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The full text of the license can be found in the LICENSE file included with this module.

perl v5.14.2							    2012-01-25						  File::HomeDir::Unix(3pm)
All times are GMT -4. The time now is 03:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy