03-06-2013
Quote:
Originally Posted by
lathanandhini
Hi All,
I am trying to calculate the total_amount based on two key fields. Here is the script. I am new to unix. So please help me to find out the error in this script.
I'm getting error like "command not found" and ]; is missing..
PRE_LBNO=0
PRE_DATE=0
TOT_PAY=0
for line in `cat dsPay_Rem_File.txt`
do
CURR_LBNO=`echo ${line} | cut -d ',' -f3`
CURR_DATE=`echo ${line} | cut -d ',' -f6`
PAY_AMT=`echo ${line} | cut -d ',' -f7`
if [ "${PRE_LBNO} = ${CURR_LBNO} && ${PRE_DATE} = ${CURR_DATE} ] || [ ${PRE_LBNO} = 0 && ${PRE_DATE} = 0"; ]
then
TOT_PAY=`expr $TOT_PAY + ${PAY_AMT}`
else
TOT_PAY=${PAY_AMT}
fi
echo ${CURR_LBNO},${CURR_DATE},${TOT_PAY} >> test_l.txt
PRE_LBNO=`echo ${CURR_LBNO}`
PRE_DATE=`echo ${CURR_DATE}`
done
this is my script.. Thanks in advance
Please go through the forum rules.
Please use
CODE TAGS
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all,
I have a file - 12.txt
cat 12.txt
===============================================
Number of executions = 2 Total execution time (sec.ms) = 0.009883
Number of executions = 8 Total execution time (sec.ms) = 0.001270
Number of... (23 Replies)
Discussion started by: Rahulpict
23 Replies
2. Shell Programming and Scripting
Trying to figure out why this works:
printpwd.pl
#!/usr/bin/perl
use CGI::Carp qw( fatalsToBrowser );
print "Content-type: text/html\n\n";
$A = system("pwd");
$A = `pwd`;
print "$A\n";
^^actually that works/breaks if that makes any sense.. i get the working directory twice but when... (5 Replies)
Discussion started by: phpfreak
5 Replies
3. UNIX for Dummies Questions & Answers
hi guys im new to unix and what to get this script working
the scripts purpose its purpose is to move files
i copy it from a HP UX pdf just for practice but
when i execute it comes up wit this error command not found
on the line if plz help me and thank in advance
to those who do ps im... (3 Replies)
Discussion started by: ShinTec
3 Replies
4. Shell Programming and Scripting
Hi all,
I have a piece of code which cork perfect. It copy the no of lines from some files (*.log) into finalLog file.
It read the lines after the line have text "ntot".
Here it is :
#!/bin/bash ... (10 Replies)
Discussion started by: nrjrasaxena
10 Replies
5. Shell Programming and Scripting
Hello,
I am facing a very strange problem when I run my script manuallu ./Fetchcode which is using to connect with MKS integrity from linux end it workks fine but when I run it from cron it doesn't work.Can someone help me
1) How could I check my script when it is running from cron like... (3 Replies)
Discussion started by: anuragpgtgerman
3 Replies
6. Shell Programming and Scripting
Help. My script is working fine when executed manually but the cron seems not to catch up the command when registered.
The script is as follow:
#!/bin/sh
for file in file_1.txt file_2.txt file_3.txt
do
awk '{ print "0" }' $file > tmp.tmp
mv tmp.tmp $file
done
And the cron... (2 Replies)
Discussion started by: jasperux
2 Replies
7. Shell Programming and Scripting
Shell Scipt: temp.sh
su - <$username>
expect pass.exp
Expect script: pass.exp
#!/usr/bin/expect -f
# Login
#######################
expect "Password: " send "<$password>\r"
it comes up with Password: but doesnt take password passed throguh file. (2 Replies)
Discussion started by: bhavesh.sapra
2 Replies
8. Shell Programming and Scripting
Hi i have write the one scripts and the scripts is error. The scripts purpose select one directory to check the file is there or not. i will give the two format of file to search the mention the path one file is there to select the file one copy the another location.please check the my script give... (1 Reply)
Discussion started by: rajivgandhi
1 Replies
9. UNIX for Beginners Questions & Answers
for file in $(find /home/p611568/*.rpt -mtime -2 | grep -v ftplog)
do
awk '$1 == "XifPages," {PAGE = $5}
$1 == "XifEndOfDocuments," {LINE = $5}
index($0,"Value") && index($1,"Info") {sevGTI = 1}
END {if (sevGTI)
printf "%7s%10s%s",PAGE,LINE
... (4 Replies)
Discussion started by: bcarosi
4 Replies
10. Shell Programming and Scripting
Hello experts,
we have input files with 700K lines each (one generated for every hour). and we need to convert them as below and move them to another directory once.
Sample INPUT:-
# cat test1
1559205600000,8474,NormalizedPortInfo,PctDiscards,0.0,Interface,BG-CTA-AX1.test.com,Vl111... (7 Replies)
Discussion started by: prvnrk
7 Replies
LEARN ABOUT PHP
mssql_num_fields
MSSQL_NUM_FIELDS(3) MSSQL_NUM_FIELDS(3)
mssql_num_fields - Gets the number of fields in result
SYNOPSIS
int mssql_num_fields (resource $result)
DESCRIPTION
mssql_num_fields(3) returns the number of fields in a result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns the number of fields, as an integer.
EXAMPLES
Example #1
mssql_num_fields(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Select some data from our database
$data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Construct a table
echo '<table border="1">';
$header = false;
// Iterate through returned results
while ($row = mssql_fetch_array($data)) {
// Build the table header
if (!$header) {
echo '<thead>';
echo '<tr>';
for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
echo '<td>' . ucfirst($row[$i]) . '</td>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$header = true;
}
// Build the row
echo '<tr>';
foreach($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '</tr>';
}
// Close table
echo '</tbody>';
echo '</table>';
// Clean up
mssql_free_result($data);
mssql_close($link);
?>
SEE ALSO
mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).
PHP Documentation Group MSSQL_NUM_FIELDS(3)