03-15-2006
An AWK question
ok, hands up im a bit of a noob when it comes to shell scripting but I am stuck on some AWK type problems that i wonder if you can help me with
My file, comma delimited, looks like this
00004290.00,000000.00
00233238.43,000000.00
00000122.67,000000.00
as you can see i have two fields $1 and $2 . I have two questions
1) in $1 (the amount field in my case), i would like to remove the leading zero's (regardless of how many there are) I realise that this will make the file no longer a fixed length file but that is no problem, as its being used for a mail merge.
2) on a slightly different note, on $2 (the outstanding balance field in my case) I need to remove the leading zeros, unless the value (as above) is actually at zero, as obviously removing the leading zeros from 000000.00 doesnt really give the desired effect.....i would like it to be the value of just "0" or "0.00" if this is the case.
any pointers or guidance on this would be greatly appreciated
Gary
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have the following error:
ls -lt | awk 'BEGIN NR > 1 { print $2, $9 }'
Syntax Error The source line is 1.
The error context is
BEGIN >>> NR <<< > 1 { print $2, $9 }
awk: 0602-500 Quitting The source line is 1.
What I want to do is ls a directory, skip the first... (3 Replies)
Discussion started by: lesstjm
3 Replies
2. Shell Programming and Scripting
Hello,
I have the following command that does 2 searches.
awk '{if ($0 ~ /STRING1/) {c++} }{if ( c == 2 ) {sub(/STRING1/,"NEWSTRING") } } { print }' FILE
How do I search up after the first search?
thanks (4 Replies)
Discussion started by: ctcuser
4 Replies
3. Shell Programming and Scripting
i have a little awk script that I use looks this:
awk '{if (FNR==1){print FILENAME; print $0}else print $0}' file1...file2....fi... > bundled.
i have completely forgotten how to unbundle this. I have tried several different approaches and still can not remember how to unbundle the file bundled.... (2 Replies)
Discussion started by: moxxx68
2 Replies
4. Shell Programming and Scripting
I am trying to read through a file, gather the states in that file and change it from an abbreviation to the ful text.
Can anyone provide some assistance.
Thanks!! (4 Replies)
Discussion started by: cnitadesigner
4 Replies
5. Shell Programming and Scripting
How I can rid of the following presentation du -sk /u*/oradata/TEST/*.dbf |awk '{print total+=$1} 1.28003e+06
4.35109e+06
4.36134e+06
4.4535e+06
5.47752e+06
5.48777e+06
7.52554e+06
7.73036e+06
9.06158e+06
:confused: thank you (3 Replies)
Discussion started by: zam
3 Replies
6. UNIX for Dummies Questions & Answers
Hi, in the following script, what does " a=$0} END " mean ?
do we need that ? Thanks
awk '{a=$0} END {for (i=NR; i>=1; i--) print a}' file (3 Replies)
Discussion started by: james94538
3 Replies
7. UNIX for Dummies Questions & Answers
Can anyone help with this this one liner:
nawk -v RS='' '$1=$1' InputFile
What I have in the file:
0.0013985457223116
-0.0002338180925628
0.0
0.0003709430584958
-0.0005763523138347
0.0
And the output I want:
0.0013985457223116 -0.0002338180925628 0.0
0.0003709430584958... (1 Reply)
Discussion started by: mookie123
1 Replies
8. UNIX for Dummies Questions & Answers
I have a script problem that I am not able to solve due my very limited understanding of unix/awk.
This is the contents of test.sh
awk '{print $1}'
From the prompt if I enter:
./test.sh Hello World
I would expect to see "Hello" but all I get is a blank line. Only then if I enter "Hello... (2 Replies)
Discussion started by: JasonHamm
2 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
im using ls -l | xargs | awk '{what ever files here}'
im trying to get something that looks like this... (7 Replies)
Discussion started by: rontopia
7 Replies
10. Shell Programming and Scripting
Hi Experts,
I am trying to get system output to capture inside awk , but not working:
Please advise if this is possible :
I am trying something like this but not working, the output is coming wrong:
echo "" | awk '{d=system ("date") ; print "Current date is:" , d }'
Thanks, (5 Replies)
Discussion started by: rveri
5 Replies
LEARN ABOUT DEBIAN
pclock
PCLOCK(1) General Commands Manual PCLOCK(1)
NAME
pclock - pixmap clock
SYNOPSIS
pclock [options]
DESCRIPTION
This manual page documents briefly the pclock command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
pclock is a program that places a small analog clock program on the desktop of X. It was designed to run under the WindowMaker window man-
ager. It uses any 64x64 pixmap as a background.
OPTIONS
The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
dash. A summary of options is included below.
-B PIXMAP, --background=PIXMAP
Use the given pixmap as the clock background (size must be 64x64).
-H COLOR, --hands-color=COLOR
Draw the hands (hour, minute and second) in the specified color.
-S COLOR, --second-hand-color
Draw the second hand in the specified color
-h, --help
Show summary of options.
--hour-hand-length=INT
Draw the hour hand with the specified length of INT.
--minute-hand-length=INT
Draw the minute hand with the specified length of INT.
--second-hand-length=INT
Draw the second hand with the specified length of INT.
--second-hand-width=INT
Draw the minute hand with the specified width of INT.
-s, --second-hand
Don't display the second hand.
-v, --version
Show version of program.
-w, --withdrawn
Don't start up in a withdrawn (iconic) state.
AUTHOR
This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others). The soft-
ware is copyrighted (c) 1998 by and released under the GPL v2.
Author: Alexander Kourakos <Alexander@Kourakos.com>
Web: http://www.kourakos.com/~awk/pclock/
PCLOCK(1)