07-06-2009
I actually figured it out on my own ---
In case anyone has questions:
using korn shell
i just looped through with this: (the column is the third in the file)
while [ $i -le $recordcount ]; do
Current=`sed -n "$i p" $File | awk '{print substr($3,length($3)-5,6)}'`
i=$((i+1))
done
since I 'm also doing some other processing individually on each field this worked for me....
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How to insert leading zeros into a left-justisfied zip code?
e.g. Zip code is written as 60320 which is left-justified to make it be read as 0060320.
We have to move it to right-justifiable then insert 2 leading zeros into it... ;) (1 Reply)
Discussion started by: wtofu
1 Replies
2. Shell Programming and Scripting
Hi All,
I am working with a fixed width file Forrmat.
C1 Number (10,3)
C2 Number (10,3)
e.g.
c1= 0000000100.000
c2= 0000000020.000
0000000100.0000000000020.000
I have to perform c1 - c2 . i.e. I want answer to be 0000000080.000. but I am loosing the leading zeros( only getting... (3 Replies)
Discussion started by: Manish Jha
3 Replies
3. Shell Programming and Scripting
How do I trim the leading zeroes, and (+,-) in the currency field ?
I have a text file.
Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06.
Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06.
I want the O/P file to be like.
Your bill of 2780.96 for a/c no. 25287324... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies
4. Shell Programming and Scripting
How do I remove or add leading zeroa from a variable. To make variable 10 characters long when adding zeros. (6 Replies)
Discussion started by: toshidas2000
6 Replies
5. Shell Programming and Scripting
Hi all,
I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16.
Example:
cat tmp.txt
502455
50255
5026
5027
5028
Output
0000000000502455
0000000000050255
0000000000005026
0000000000005027
0000000000005028
Any... (12 Replies)
Discussion started by: jakSun8
12 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
How does one trim leading zero's in unix
Thanks
KP. (7 Replies)
Discussion started by: kingofprussia
7 Replies
7. Shell Programming and Scripting
Hi
i need help in adding leading zero to filenames
e.g file name in my folder are
1_234sd.txt
23_234sd.txt
the output i need is
001_234sd.txt
023_234sd.txt
can i do this shell scripting
please help (2 Replies)
Discussion started by: rsmpk
2 Replies
8. Shell Programming and Scripting
Hi,
i have a variable which conatins values like 00001,0003,00067,00459.
I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459.
Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
Discussion started by: arijitsaha
5 Replies
9. Shell Programming and Scripting
I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc
this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies
10. Shell Programming and Scripting
I have a below file and I wanted to remove the leading zeros in each field separated by pipe
File:
01/09/2017|2017/09/06|2017/02/06|02/06/2017|02/06/2017 06:50:06 AM|2017/02/06|02/06/2017|02/07/2017 05:45:06 AM|
02/08/2017|2017/08/06|2017/09/06|02/05/2017|02/07/2017 05:40:06... (4 Replies)
Discussion started by: Joselouis
4 Replies
LEARN ABOUT DEBIAN
shtool-table
SHTOOL-TABLE.TMP(1) GNU Portable Shell Tool SHTOOL-TABLE.TMP(1)
NAME
shtool-table - GNU shtool pretty-print a field-separated list
SYNOPSIS
shtool table [-F|--field-sep sep] [-w|--width width] [-c|--columns cols] [-s|--strip strip] strsepstr...
DESCRIPTION
This pretty-prints a list of strings as a table.
OPTIONS
The following command line options are available.
-F, --field-sep sep
Separate columns using sep. Default is ":".
-w, --width width
Width of each column. Default is 15 characters.
-c, --columns cols
Number of columns. Default is 3.
-s, --strip strip
Strip off any characters past strip. Default is 79.
EXAMPLE
# shell script
shtool table -F , -w 5 -c 4 "1,2,3,4,5,6,7,8,9,10,11,12"
HISTORY
The GNU shtool table command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 1999 for GNU shtool.
SEE ALSO
shtool(1), tr(1), fmt(1), sh(1), awk(1), sed(1).
18-Jul-2008 shtool 2.0.8 SHTOOL-TABLE.TMP(1)