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 CENTOS

file::spec::functions

File::Spec::Functions(3)				User Contributed Perl Documentation				  File::Spec::Functions(3)

NAME

       File::Spec::Functions - portably perform operations on file names

SYNOPSIS

	       use File::Spec::Functions;
	       $x = catfile('a','b');

DESCRIPTION

       This module exports convenience functions for all of the class methods provided by File::Spec.

       For a reference of available functions, please consult File::Spec::Unix, which contains the entire set, and which is inherited by the
       modules for other platforms. For further information, please see File::Spec::Mac, File::Spec::OS2, File::Spec::Win32, or File::Spec::VMS.

   Exports
       The following functions are exported by default.

	       canonpath
	       catdir
	       catfile
	       curdir
	       rootdir
	       updir
	       no_upwards
	       file_name_is_absolute
	       path

       The following functions are exported only by request.

	       devnull
	       tmpdir
	       splitpath
	       splitdir
	       catpath
	       abs2rel
	       rel2abs
	       case_tolerant

       All the functions may be imported using the ":ALL" tag.

COPYRIGHT

       Copyright (c) 2004 by the Perl 5 Porters.  All rights reserved.

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

SEE ALSO

       File::Spec, File::Spec::Unix, File::Spec::Mac, File::Spec::OS2, File::Spec::Win32, File::Spec::VMS, ExtUtils::MakeMaker

perl v5.16.3							    2013-01-16						  File::Spec::Functions(3)
All times are GMT -4. The time now is 06:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy