03-21-2009
AWK Currency Conversion
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
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: rohanrege
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: charandevu
2 Replies
3. Shell Programming and Scripting
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)
Discussion started by: gehlnar
6 Replies
4. Shell Programming and Scripting
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)
Discussion started by: insania
1 Replies
5. Shell Programming and Scripting
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)
Discussion started by: rk4k
3 Replies
6. Shell Programming and Scripting
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)
Discussion started by: beow
4 Replies
7. Shell Programming and Scripting
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)
Discussion started by: rpf
6 Replies
8. Shell Programming and Scripting
hi all,
I had my script as
a=qw
b=rter
c=fdfd
curency=1000
printf"${curency} $a $b $c" > filename
can i have printf statement that can change the currency from 1000 to 1,000 like it should convert the number to currency format ..?(i.e for any number) (14 Replies)
Discussion started by: hemanthsaikumar
14 Replies
9. Shell Programming and Scripting
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:
$1 + 0 == $1 It works most of the time, but in some cases it does not behave how I expect it to... (5 Replies)
Discussion started by: migurus
5 Replies
10. Shell Programming and Scripting
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
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).
Free Software Foundation Nov 3 1999 IGAWK(1)