I am running into conversion of string to numbers in awk that I can't understand and don't know how to deal with properly
My script checks for numeric only field, I use this approach to do that:
It works most of the time, but in some cases it does not behave how I expect it to behave, for example for value 673E5 script wrongly assumes it is numeric.
Please see below a series of values and how it is converted, hope it makes my question clearer:
I used both awk and gawk, same reaction.
See how last example is badly converted and compare comes back with positive somehow.
What do I do wrong?
I am porting a awk script from Windows to unix
I_SALE_MEDIA=$67
if ((I_VOID_FLAG == "Y") && (I_SALE_MEDIA == 0))
NOW consider the case where I_SALE_MEDIA i.e $67 is "000"
The above comparison works fine in Windows , but to make it work in
Unix , I had to change the above as follows :
... (3 Replies)
hi
awk script for dd/mm/yyyy to yyyymmdd
awk script for dd-mon-yyyy to yyyymmdd
awk script for dd-mm-yyyy to yyyymmdd formate
..............urgent.............
Thanks in advanced (2 Replies)
How can I use awk command to convert values to currency. For example I have a database like follows
John:200
smith:300
kim:405
and want it to out put like this
John $200.00 (3 Replies)
Hi Everyone,
I am confused with the output of the input file and I am using below command in script to get the expected output.
Also I want to add another condition using logical AND (&&) in place of $2=="L"{$4=0-$4} as $2=="L" && $3=="L" {$4=0-$4} but I am getting some awk error.
Can someone... (6 Replies)
I have the following script to edit ^'s and newlines out of files to be entered into a database. This script has been around since the dawn of time (way before me).
#!/bin/bash
# Remove all ^ and \n from the source file, except do not remove ^^^\n
cat myfile.hold | awk '
BEGIN {FS="|";... (1 Reply)
I have the words in twiki format that I want to convert to mediawiki format like below :
%BLUE%some words1%ENDCOLOR%
bla bla blab labdad sdadasd adsasdads oerdkfj kdfjs %PINK%some wordks2 123.4.5.6/26%ENDCOLOR%, ksdjak dkasjd kjfrjkfgjdkfgjdfkgjdgdfgdgf %PURPLE%1.2.3.4/28%ENDCOLOR%, dskd... (3 Replies)
Can someone explain whats happening here:
$ awk 'BEGIN {print (2.5 - 1)}'
1,5
2.5 - 1 is correctly calculated to 1,5 (using european locale)
$ echo "2.5" | awk '{temp = $1 - 1; print temp}'
1
If i now pipe the string 2.5 through awk it seems at it truncates 2.5 to 2?
What's the... (4 Replies)
Hello friends, could you help me about problem with my data lines. I suppose a simple awk code may help me.
I have following data lines: (first line including 3 numbers and then a matrices of 4x10)
500 40 9
1 A B 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22... (6 Replies)
hi,
problem:
output is not consistent as expected using external command in AWK
description:
I'm trying to convert $2 into a base64 string for later decoding, and for this when I use awk , I'm getting overlapped results , or say it results are not 100% correct.
my code is:
gawk... (9 Replies)
Discussion started by: busyboy
9 Replies
LEARN ABOUT OPENSOLARIS
igawk
IGAWK(1) Utility Commands IGAWK(1)NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+-----------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+-----------------+
|Availability | SUNWgawk |
+--------------------+-----------------+
|Interface Stability | Volatile |
+--------------------+-----------------+
NOTES
Source for gawk is available on http://opensolaris.org.
Free Software Foundation Nov 3 1999 IGAWK(1)