Sponsored Content
Top Forums Shell Programming and Scripting How to trim the leading zeroes in a Currency field ? Post 302119277 by panknil on Tuesday 29th of May 2007 03:37:09 AM
Old 05-29-2007
Bug How to trim the leading zeroes in a Currency field ?

Dear Amruta Pitkar,

The code
awk '$4 ~ /^+/{ sub(/^\+0+/,"",$4) }{print $0}' MyFile.txt
is working fine.there is no prob with this code...
i think you r doing some mistake by your own.
just check your input file.
else just copy this for your input 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.

save it and execute it...this is working fine...

Regards,
Pankaj
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

trim leading zero in certain column in a string

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

Add leading zeroes to numbers in a file

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

How to left trim padded zeroes

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

how to check and remove leading zeroes from the buffer using c program

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

Trim leading zeros to make field 6 characters long

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

insert leading zeroes based on the character count

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

sed not removing leading zeroes

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

Remove leading zeroes in 2nd field using sed

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

awk and leading zeroes

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

Pad zeroes first field in a Delimited file

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
on(1)							      General Commands Manual							     on(1)

NAME
on - execute command on remote host with environment similar to local SYNOPSIS
| host [command [argument] ... ] DESCRIPTION
executes a command on a remote host, using an environment similar to that of the invoking user where: host specifies the name of the host on which to execute the command. command specifies the command to execute on host If command is not specified, starts a shell on host. argument ... is a list of arguments for command. The user's environment variables are copied to the remote host, and the file system containing the user's current working directory is NFS mounted on the remote host (see nfs(7)). The command is executed on the remote host in the user's current working directory. Commands using relative path names that reference file system objects within the user's current working file system have the same behavior as running the command on the client. The behavior of commands using relative path names that cross the file system boundary or commands using absolute path names depends on the organization of the remote host's file system. Implicit and explicit use of environment variables may also cause a command's behavior to be dependent on the organization of the remote host's file system. For example, the environment variable usually contains absolute path names. Standard input, output and error of the remote command are connected to the appropriate file descriptors on the client. The remote execution daemon does not allow to execute a remote command. The signals and are propagated to the remote command. and are ignored by the remote command. All other signals are delivered to the com- mand. In order to execute a remote command, the remote host must be configured to execute (see rexd(1M)). Options recognizes the following options: Interactive mode. This option is required for commands that must communicate with a terminal such as or Terminal mode changes are propagated to the server. The standard input for an interactive command must be a tty device. The and options are mutually exclusive. Debug mode. Print diagnostic messages during startup of the command. These messages are useful for detecting configuration problems if the command to a specific host is failing. No input mode. This option causes the remote command to get end-of-file (EOF) when it reads from standard input, instead of connecting the standard input of the command to the standard input of the remote command. The option is required when running commands in the background. The and options are mutually exclusive. DIAGNOSTICS
The host name host was not found in the hosts database. The host host is down, unreachable on the network, or not running A problem occurred trying to find the user's current working directory (current_dir). A problem occurred trying to determine the mount point of the user's current working directory (current_dir). The standard input (stdin) of the command with the option is not a tty device. Errors that occur on the server server are propagated back to the client. These messages are documented in the DIAGNOSTICS section of rexd(1M). AUTHOR
was developed by Sun Microsystems, Inc. SEE ALSO
exports(4), rexd(1M). on(1)
All times are GMT -4. The time now is 05:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy