05-29-2007
How to trim the leading zeroes in a Currency field ?
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 is due on 11-06.
Your bill of 422270.48 for a/c no. 28931373 is due on 11-06.
One of the possible ways I cud think was to write a small function to read char by char and remove the leading zeroes. Is there any other quicker and effcient way ?
Any suggestions ?
Thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I would like to know how to trim leading zero only in certain column of of a string, example:
hdhshdhdhd000012mmmm0002abc <===== before
hdhshdhdhd 12mmmm 2abc <===== after
Thanks for your help. (2 Replies)
Discussion started by: dngo
2 Replies
2. Shell Programming and Scripting
Hello, I am (trying) to write a script that will check to see how many users are logged on to my machine, and if that number is more than 60 I need to kill off all the oldest sessions that are over 60. So far I have been able to check how many users are on and now I am at the part where I have to... (3 Replies)
Discussion started by: raidzero
3 Replies
3. UNIX for Dummies Questions & Answers
I have a filename 'INITIATE_FINAL_ALL_000080889.dat', and I want to capture just the number '80889' from it.
Here is what I have so far:
%> echo INITIATE_FINAL_ALL_000080889.dat | sed "s/*//g"
000080889
Now, I just need to trim off the padded zeroes.
Thanks,
- CB (3 Replies)
Discussion started by: ChicagoBlues
3 Replies
4. Programming
Helo ,
I m writing small module of c.on RHEL 4
I have one buffer (for e.g. buffer = "002"
now I want to check whethere buffer contains leading zeroes and if it contains
leading zeroes then I want to remove all leading zeroes
( i.e. if buffer = "002" then I want to make buffer = "2")
how... (1 Reply)
Discussion started by: amitpansuria
1 Replies
5. Shell Programming and Scripting
Hi all-
I've got a file that will have multiple columns. In one column there will be a string that is 10 digits in length, but I need to trim the first four zeros to make it 6 characters?
example:
0000001234
0000123456
0000234566
0000000321
output:
001234
123456
234566
000321 (5 Replies)
Discussion started by: Cailet
5 Replies
6. Shell Programming and Scripting
Hi,
I need add leading zeroes to a field in a file based on the character count. The field can be of 1 character to 6 character length. I need to make the field 14bytes.
eg:
8351,20,1
8351,234,6
8351,2,0
8351,1234,2
8351,123456,1
8351,12345,2
This should become.
... (3 Replies)
Discussion started by: gpaulose
3 Replies
7. Shell Programming and Scripting
I have th following file
0000000011
0000000001
0000000231
0000000001
0000000022
noow when i run the following command
sed 's/^0+//g' file name
I receive the same output and the leading zeroes are not removed from the file . Please let me know how to achieve... (4 Replies)
Discussion started by: asalman.qazi
4 Replies
8. Shell Programming and Scripting
Hi Forum.
I tried searching the forum but couldn't find a solution for my question.
I have the following data and would like to have a sed syntax to remove the leading zeroes from the 2nd field only:
Before:
2010-01-01|123|1|1000|2000|500|1500|600|700... (18 Replies)
Discussion started by: pchang
18 Replies
9. Shell Programming and Scripting
I have the following script that renames filenames like:
blah_bleh_91_2011-09-26_00.05.43AM.xls
and transforms it in:
91_20110926_000543_3_blih.xls
for a in *.xls;
do
b="$(echo "${a}" | cut -d '_' -f4)"
dia=`echo ${b} | cut -c9-10`
mes=`echo ${b} | cut -c6-7`
anio=`echo ${b} | cut -c1-4`... (4 Replies)
Discussion started by: Tr0cken
4 Replies
10. Shell Programming and Scripting
Need help. I tried using an awk command to pad zeroes. Unfortunately, the "|" pipe delimited character is gone when I tried to write the records to another file.
awk -F \| ' {$1=sprintf("%06s", $1); print $0}' $CUSTFINAL2 > $CUSTFINAL3
BEFORE
"KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT... (3 Replies)
Discussion started by: johnhips
3 Replies
group(5yp) group(5yp)
Name
group - group file in a Yellow Pages environment
Description
For each group, the file contains:
Group name
Encrypted password
Numerical group ID
Comma-separated list of all users allowed in the group
This is an ASCII file. The fields are separated by colons. Each group is separated from the next by a new-line. If the password field is
null, no password is needed.
This file resides in the directory. Because of the encrypted passwords, it can and does have general read permission and can be used, for
example, to map numerical group ID's to names.
A group file can have a line beginning with a plus (+), which means to incorporate entries from the Yellow Pages. There are two styles of
+ entries: All by itself, + means to insert the entire contents of the Yellow Pages group file at that point; +name means to insert the
entry (if any) for name from the Yellow Pages at that point. If a + entry has a password or group member field that is not null, the con-
tents of that field will override what is contained in the Yellow Pages. The numerical group ID field cannot be overridden.
Examples
+myproject:::bill, steve
+:
If these entries appear at the end of a group file, then the group myproject will have members bill and steve, and the password and group
ID of the Yellow Pages entry for the group myproject. All the groups listed in the Yellow Pages will be pulled in and placed after the
entry for myproject.
Restrictions
The command will not change group passwords.
Files
ULTRIX file system group file
Yellow Pages group map
See Also
yppasswd(1yp), setgroups(2), crypt(3), initgroups(3x), passwd(5yp)
group(5yp)