Help with script Post: 302275179

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Help with script Post 302275179 by wendyz on Friday 9th of January 2009 12:43:07 PM

01-09-2009

Registered User

Help with script

I have two files, how to open them and read files, then company two files, if the item in first file is the same name in second file, then add qty number in second file and attach the number to first file.

file1:
NAME DESCRIPTION WHSE BEGQTY ONHAND
-----------------------------------------------------------------
ABC ABC COMPANY CA 32 34
ACB ACB COMPANY CA 5 18
ERC ERC COMAPNAY TX 10 4

file2:
NAME DESCRIPTION WHSE TRXCD QTY
-------------------------------------------------------------------
ABC ABC COMPANY CA 1 10
ABC ABC COMPANY CA 1 3
ABC ABC COMPANY CA 4 -9
ABC ABC COMPANY CA 4 -5
ACB ACB COMPANY CA 1 8
ACB ACB COMPANY CA 1 10
ACB ACB COMPANY CA 4 -3
ACB ACB COMPANY CA 4 -5
ERC ERC COMPANY TX 1 11
ERC ERC COMPANY TX 4 -5
ERC ERC COMPANY TX 4 -10

the result should be:

NAME DESCRIPTION WHSE BEGQTY RECEVIED ADJUST SOLD ONHAND
-----------------------------------------------------------------------
ABC ABC COMPANY CA 32 13 -3 14 34
ACB ACB COMPANY CA 5 18 -3 8 18
ERC ERC COMPANY TX 10 11 2 15 4

Condition is:
if (file1 name = file2 name && file1 whse = file2 whse)
then
if(file2 trxcd = 1)
then
add qty number, get subtotal to recevied field
if(file2 trxcd = 4)
then
add qty number, get subtotal to sold field

adjust = begqty + received - sold - onhand

I write program using java language and can run under windows, but I want to know how to run it using shell script on Unix.

wendyz

View Public Profile for wendyz

Find all posts by wendyz

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table...

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ...

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"...

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"...

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My...

LEARN ABOUT DEBIAN

authen::simple

Authen::Simple(3pm)					User Contributed Perl Documentation				       Authen::Simple(3pm)

NAME

       Authen::Simple - Simple Authentication

SYNOPSIS

	   use Authen::Simple;
	   use Authen::Simple::Kerberos;
	   use Authen::Simple::SMB;

	   my $simple = Authen::Simple->new(
	       Authen::Simple::Kerberos->new( realm => 'REALM.COMPANY.COM' ),
	       Authen::Simple::SMB->new( domain => 'DOMAIN', pdc => 'PDC' )
	   );

	   if ( $simple->authenticate( $username, $password ) ) {
	       # successfull authentication
	   }

DESCRIPTION

       Simple and consistent framework for authentication.

METHODS

       o   new

	   This method takes an array of "Authen::Simple" adapters. Required.

       o   authenticate( $username, $password )

	   Returns true on success and false on failure.

SEE ALSO

       Authen::Simple::ActiveDirectory.

       Authen::Simple::CDBI.

       Authen::Simple::DBI.

       Authen::Simple::FTP.

       Authen::Simple::HTTP.

       Authen::Simple::Kerberos.

       Authen::Simple::LDAP.

       Authen::Simple::NIS.

       Authen::Simple::PAM.

       Authen::Simple::Passwd.

       Authen::Simple::POP3.

       Authen::Simple::RADIUS.

       Authen::Simple::SMB.

       Authen::Simple::SMTP.

       Authen::Simple::SSH.

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

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

perl v5.14.2							    2012-04-19						       Authen::Simple(3pm)