12-15-2006
#! /usr/bin/ksh
rm result1
while read line
do
gl=`echo $line | cut -d\* -f1`
obal=`echo $line | cut -d\* -f4`
#echo "Opening Balance : $obal" >> result1
cat file2 |awk -F* 'BEGIN{opbl=0}
{if($3 == g){
if(opbl == 0) {
print "Opening Balance :" totbal
opbl=1
}
totbal = totbal + $7
{print $5 " " $6" " g " "$7}
}
}END{print "Total Balance : " totbal"\n" }' g="$gl" totbal="$obal" >>result1
done < file1
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
We currently use the following script to format a non formatted file to an 80 byte format (for grep purposes etc..) We need some assistance with converting the file back to a non formatted file with no carriage returns ( we want the file to be a continuous line)
#!/usr/local/bin/perl
($fn,... (1 Reply)
Discussion started by: rivera
1 Replies
2. Shell Programming and Scripting
Hi,
I have 2 files that I got as an output from another program. They are :
File 1
((((((CtBJa:197.0,CtBTz:197.0):85.0,CtAHr:197.0):116.0,CtDUw:197.0):176.0,CtSwe:197.0):110.0,
(CtL2b:197.0,Ct4Bu:197.0):196.0):197.0,CmuNg:197.0);... (5 Replies)
Discussion started by: Lucky Ali
5 Replies
3. Shell Programming and Scripting
how do i add the directory name to multiple flies and pad numbers sequences
/bin/bin2/bin3/bin4/bin5/foo_bar_vX/foobar
ie i have a pic in the foobar folder call dsc.1
id like to change it to foobar_dsc.0001 (2 Replies)
Discussion started by: thehive
2 Replies
4. Shell Programming and Scripting
Hi,
Can anyone tell me how i can convert all tab spaces inside a script to 4 spaces through another script.
Also i need to find if all the quotes are matching and ended properly. Any idea whould be of great help.
Many thanks! (3 Replies)
Discussion started by: justchill
3 Replies
5. Shell Programming and Scripting
I have 'n' number of files in a folder .each file in the folder "myfolder" is having the content like.
COLNAME
------------
AAAAAA
BBBBBB
CCCCCC
DDDDDD
...
...
...
ZZZZZZ
26 recrod(s) selected.
My request is by reading each file in "myfolder" and format each file such a way... (18 Replies)
Discussion started by: rocking77
18 Replies
6. UNIX for Dummies Questions & Answers
Hi
I am fetcthing the data from the oracle database using SQLPLUS. Here is my script
#!/bin/ksh
echo `sqlplus -s <<EOF
set feedback off
set linesize 5000
set pages 0
set space 0
set echo off
set trimspool on
set colsep '|'
SELECT col1 , col2... (4 Replies)
Discussion started by: max_hammer
4 Replies
7. Shell Programming and Scripting
Our vendor produces a report that I would like to format in a particular way.
Here is the sample output from their report:
# AA.INDEX 2 11 2 239 52 (7,2) 07 MAY 11 203.1 55
# ACCOUNT 2 89561 2 ... (4 Replies)
Discussion started by: thaller
4 Replies
8. Shell Programming and Scripting
Data
I was trying to write shell script which will be return the output in the below format
First i was trying to do these using sed.
sed -n '/.ksh/p' mainksh.ksh
sed -e 's/*\(.*\)/\1/g' mainksh.ksh
$RUN_DIR, $SUB_DIR and the variables which will be defined in the profile file.
when i am... (0 Replies)
Discussion started by: rameshds
0 Replies
9. Shell Programming and Scripting
Hi I have multiple files in a folder and one file which contains a list of files (one on each line). I was to search for a string only within these files and not the whole folder. I need the output to be in the form
File1<tab>string instance 2<tab> string instance 2<tab>string instance 3... (6 Replies)
Discussion started by: pkabali
6 Replies
10. Shell Programming and Scripting
I have the following 2 output files, one contain the standard output after i decrypt the encrypted file and another keys listed from the gpg trust db,
Provider File:
gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29
"JKL <400@abc.com>"
gpg: encrypted with 2048-bit... (2 Replies)
Discussion started by: Ariean
2 Replies
LEARN ABOUT CENTOS
slamrg
slamrg.f(3) LAPACK slamrg.f(3)
NAME
slamrg.f -
SYNOPSIS
Functions/Subroutines
subroutine slamrg (N1, N2, A, STRD1, STRD2, INDEX)
SLAMRG creates a permutation list to merge the entries of two independently sorted sets into a single set sorted in ascending order.
Function/Subroutine Documentation
subroutine slamrg (integerN1, integerN2, real, dimension( * )A, integerSTRD1, integerSTRD2, integer, dimension( * )INDEX)
SLAMRG creates a permutation list to merge the entries of two independently sorted sets into a single set sorted in ascending order.
Purpose:
SLAMRG will create a permutation list which will merge the elements
of A (which is composed of two independently sorted sets) into a
single set which is sorted in ascending order.
Parameters:
N1
N1 is INTEGER
N2
N2 is INTEGER
These arguements contain the respective lengths of the two
sorted lists to be merged.
A
A is REAL array, dimension (N1+N2)
The first N1 elements of A contain a list of numbers which
are sorted in either ascending or descending order. Likewise
for the final N2 elements.
STRD1
STRD1 is INTEGER
STRD2
STRD2 is INTEGER
These are the strides to be taken through the array A.
Allowable strides are 1 and -1. They indicate whether a
subset of A is sorted in ascending (STRDx = 1) or descending
(STRDx = -1) order.
INDEX
INDEX is INTEGER array, dimension (N1+N2)
On exit this array will contain a permutation such that
if B( I ) = A( INDEX( I ) ) for I=1,N1+N2, then B will be
sorted in ascending order.
Author:
Univ. of Tennessee
Univ. of California Berkeley
Univ. of Colorado Denver
NAG Ltd.
Date:
September 2012
Definition at line 100 of file slamrg.f.
Author
Generated automatically by Doxygen for LAPACK from the source code.
Version 3.4.2 Tue Sep 25 2012 slamrg.f(3)