Awk or If/statement Calculation Problem Post: 302705191

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with float calculation and awk

Hi All, can some body help me to script the below logic. Basically am facing problem with float calculation. Also i need this to be done inside a single awk. I tried lot of tuning but still nothing is getting displayed, nor any errors param=50 value=19.23 for(i=0;i<4;i++) {...

2. Shell Programming and Scripting

awk calculation problem

I have a list of coordinate data, sampled below. 54555209 784672723 I want it as: 545552.09 7846727.23 Below is my script: BEGIN {FS= " "; OFS= ","} {print $1*.01,$2*.01} This is my outcome: 5.5e7 7.8e8 How do I tell awk that I want to keep all the digits instead of outputting...

3. Shell Programming and Scripting

Problem with awk and if statement

Hi, I have a task where i need to compare columns of two files. First file is $REG_InputFileName: "UPDATE","1010021126","1-01-01","USD" "UPDATE","1013000101","1-01-01","THB" "UPDATE","1013010107","1-01-01","THB" "UPDATE","1110011122","1-01-01","USD"...

4. Shell Programming and Scripting

Problem in echo value after some calculation

val=21 total=3250 echo "`echo "scale=2; $val*100/$total" | bc`" Output: .64 How do i show the output become "0.64" instead of ".64" ?? Someone can help?

5. Shell Programming and Scripting

Decimal number calculation problem

I have a below snippet of code from my perl script and its causing a problem when the output of $lTAX is 0 (zero) its getting displayed as -0.00. I want output to be 0 not -0.00. Any help would be appreciated. #!/usr/bin/perl my $lTotA = 50.94; my $lVatA = 8.49; my $lAllocD; my $lAdjNr =...

6. UNIX for Advanced & Expert Users

Need to remove leading space from awk statement space from calculation

I created a awk state to calculate the number of success however when the query runs it has a leading zero. Any ideas on how to remove the leading zero from the calculation? Here is my query: cat myfile.log | grep | awk '{print $2,$3,$7,$11,$15,$19,$23,$27,$31,$35($19/$15*100)}' 02:00:00...

7. Shell Programming and Scripting

Awk/sed problem to write Db insertion statement

Hi There, I am trying to load data from a csv file into a DB during our DB migration phase. I am successfully able export all data into a .csv file but those have to rewritten in terms insert statement which will allow for further population of same data in different DB My exiting csv record...

8. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE...

9. Shell Programming and Scripting

awk split and awk calculation in the same command

I am trying to run the awk below. My question is when I split the input, then run anotherawk to perform a calculation using that splitas the input there are no issues. When I try to combine them the output is not correct, is the split not working or did I do it wrong? Thank you :). input ...

10. Shell Programming and Scripting

awk calculation with zero as N/A

In the below awk, I am trying to calculate percent for a given id. It is very close the problem is when the # being used in the calculation is zero. I am not sure how to code this condition into the awk as it happens frequently. The portion in italics was an attempt but that lead to an error. Thank...

LEARN ABOUT FREEBSD

whereis

WHEREIS(1)						    BSD General Commands Manual 						WHEREIS(1)

NAME

     whereis -- locate programs

SYNOPSIS

     whereis [-abmqsux] [-BMS dir ... -f] program ...

DESCRIPTION

     The whereis utility checks the standard binary, manual page, and source directories for the specified programs, printing out the paths of any
     it finds.	The supplied program names are first stripped of leading path name components, any single trailing extension added by gzip(1),
     compress(1), or bzip2(1), and the leading 's.' or trailing ',v' from a source code control system.

     The default path searched is the string returned by the sysctl(8) utility for the ``user.cs_path'' string, with /usr/libexec and the current
     user's $PATH appended.  Manual pages are searched by default along the $MANPATH.  Program sources are located in a list of known standard
     places, including all the subdirectories of /usr/src and /usr/ports.

     The following options are available:

     -B      Specify directories to search for binaries.  Requires the -f option.

     -M      Specify directories to search for manual pages.  Requires the -f option.

     -S      Specify directories to search for program sources.  Requires the -f option.

     -a      Report all matches instead of only the first of each requested type.

     -b      Search for binaries.

     -f      Delimits the list of directories after the -B, -M, or -S options, and indicates the beginning of the program list.

     -m      Search for manual pages.

     -q      (``quiet'').  Suppress the output of the utility name in front of the normal output line.	This can become handy for use in a back-
	     quote substitution of a shell command line, see EXAMPLES.

     -s      Search for source directories.

     -u      Search for ``unusual'' entries.  A file is said to be unusual if it does not have at least one entry of each requested type.  Only
	     the name of the unusual entry is printed.

     -x      Do not use ``expensive'' tools when searching for source directories.  Normally, after unsuccessfully searching all the first-level
	     subdirectories of the source directory list, whereis will ask locate(1) to find the entry on its behalf.  Since this can take much
	     longer, it can be turned off with -x.

EXAMPLES

     The following finds all utilities under /usr/bin that do not have documentation:

	   whereis -m -u /usr/bin/*

     Change to the source code directory of ls(1):

	   cd `whereis -sq ls`

SEE ALSO

     find(1), locate(1), man(1), which(1), sysctl(8)

HISTORY

     The whereis utility appeared in 3.0BSD.  This version re-implements the historical functionality that was lost in 4.4BSD.

AUTHORS

     This implementation of the whereis command was written by Jorg Wunsch.

BUGS

     This re-implementation of the whereis utility is not bug-for-bug compatible with historical versions.  It is believed to be compatible with
     the version that was shipping with FreeBSD 2.2 through FreeBSD 4.5 though.

     The whereis utility can report some unrelated source entries when the -a option is specified.

BSD
								  August 22, 2002							       BSD