Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing trailing zeroes
Top Forums Shell Programming and Scripting Removing trailing zeroes Post 302398928 by anbu23 on Friday 26th of February 2010 12:54:34 AM
Old 02-26-2010
Quote:
Originally Posted by daptal
It works fine for me anbu23
Code:
 echo 1200.00200300 | awk '{ if ($0 ~ /\./){ sub("0*$","",$0); sub ("\.$","",$0);} print}'
1200.002003

In fact what u gave will break for whole numbers
Code:
 echo 100 | awk -F"," -v OFS="," ' { for(i=0;NF- i++;){sub("[.]*0+ *$","",$i)};$1=$1 }1 '
1

I added a slash and it worked for me
Code:
$ echo 1200.00200300 | awk '{ if ($0 ~ /\./){ sub("0*$","",$0); sub ("\\.$","",$0);} print}'
1200.002003

You are right. My code will break for whole numbers. Here is the fixed code

Code:
echo 1200,135.000000,12.30100,3212.3200,1.759403,1230,101.101010,100.000000 | awk -F"," -v OFS="," ' { for(i=0;NF-i++;){ if($i ~ /[.]/){ sub("[.]*0+ *$","",$i) }}$1=$1}1'
1200,135,12.301,3212.32,1.759403,1230,101.10101,100

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

re: removing trailing space from lines

Not sure why this thread was closed without any explanation, but you can do what you're asking with sed 's/]*$//g' < sourceFile > destFile (1 Reply)
Discussion started by: oombera
1 Replies

2. Shell Programming and Scripting

sed: removing any and all trailing digits?

We have a large number of oracle database related scripts that utilize the environment variables $ORACLE_SID and $DBNAME. In a single instance database the $ORACLE_SID is the same as the database name $DBNAME. So we have simply set DBNAME = $ORACLE_SID. However, now that we are clustering with RAC,... (5 Replies)
Discussion started by: Squeakygoose
5 Replies

3. Shell Programming and Scripting

Removing leading and trailing spaces only in PERL

Hi All, I have a file with the following contents with multiple lines 172445957| 000005911|8| 400 Peninsula Ave.#1551 | And,K |935172445957|000005911 607573888 |000098536 | 2|Ane, B |J |Ane |1868 |19861206|20090106|20071001 I want to trim the "leading and trailing spaces only" from... (2 Replies)
Discussion started by: kumar04
2 Replies

4. 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

5. Shell Programming and Scripting

Removing trailing zeros using sed

Hello All, I have a csv file with 3 columns. The file which looks like this 47850000,100,233 23560000,10000,456 78650000,560000,54 34000000,3456,3 The first column has 4 trailing zeros. I have to remove 4 trailing zeroes from 1st field. The output file should appear as follows. ... (12 Replies)
Discussion started by: grajp002
12 Replies

6. UNIX for Dummies Questions & Answers

Removing the trailing date from a filename

Hi I have 3 files (say) in a folder as in the example below abc_01012011.csv def_01012011.csv xyz_01012011.csv I need to move these files to a different folder as follows abc.csv def.csv xyz.csv I am trying to put together a script with a for loop which reads the source filenames... (5 Replies)
Discussion started by: bobsn
5 Replies

7. Shell Programming and Scripting

Removing just the trailing commas :-(

Hi all, I haven't needed to do any shell based editing for nearly 20 years, and no amount of searching around has found me a solution to this very simple problem :-( I have a csv file. Some lines have three commas at the end. This means the invoice hasn't been paid. I'd like to use sed / grep... (4 Replies)
Discussion started by: chardyzulu
4 Replies

8. UNIX for Dummies Questions & Answers

Removing trailing characters

I have been given a shell script that I need to amend. To do the following extract the filename from the flag file by removing the .flag extension. # Local variables # Find if the flag files exists MASK=coda_mil2*.flag # Are there any files? bookmark="40" fileFound=0 ls -1... (3 Replies)
Discussion started by: andymay
3 Replies

9. UNIX for Dummies Questions & Answers

Removing trailing x'0A' characters.

I am trying to remove trailing carriage return (x'0a') from a source program. What is a good way to do this for the whole file? TIA (4 Replies)
Discussion started by: wbport
4 Replies

10. Shell Programming and Scripting

Removing Trailing Line

I have been trying to remove empty lines and lines just filled with spaces. I have used the following command which does work. sed -i "/^\s*$/d" Except it leaves one single trailing line at the very end of the file. For the life of me I cant figure out why I cant remove that last trailing... (2 Replies)
Discussion started by: user8282892
2 Replies

LEARN ABOUT DEBIAN

lavadecode

lavadecode(1)						      General Commands Manual						     lavadecode(1)

NAME

       lavadecode - Decode a LAVAFLOW stream into human readable form.

SYNOPSIS

       lavadecode [options] <lavaflow-file

DESCRIPTION

       lavadecode decodes a LAVAFLOW stream into human readable form.

       A LAVAFLOW stream is the printer langauge used by some Konica Minolta printers, such as the KM magicolor 2530 DL.

COMMAND LINE OPTIONS

       These are the options that can appear on the command line.

       -d basename
	      Basename of .pbm file for saving decompressed planes.

       -h     Print hex file offsets.

       -o     Print file offsets.

       -D level
	      Set Debug level [0].

EXAMPLES

       Decode an LAVAFLOW stream file created by foo2lava.

       $ lavadecode -h < testpage.prn
	    0: 33%-12345X@PJL JOB NAME="stdin"
	   1f: 33%-12345X@PJL JOB USERNAME=""
	   3d: 33%-12345X@PJL JOB TIMESTAMP="07/20/2007"
	   66: 33%-12345X@PJL JOB OSINFO="Linux/2.6.20-1.2316.fc5"
	   99: 33%-12345X@PJL ENTER LANGUAGE=LAVAFLOW
	   bf: 33E		      RESET
	   c1: 33&l0S 	      DUPLEX: [off]
	   c6: 33&l0G
	   cb: 33&u1200D	      X RESOLUTION: [1200]
	   d3: 33&l1X 	      COPIES: [1]
	   d8: 33&x1X 	      TRANSMIT ONCE COPIES: [1]
	   dd: 33&l0O 	      ORIENTATION: [port]
	   e2: 33*r1U 	      NBIE: [1]
	   e7: 33*g8W 	      BW/COLOR: [8]
				       fmt=2 np=1
				       BLACK:  X=1200, Y=600, unk=0, #=4(2)
	   f4: 33*b1234M	      COMPRESSION: [1234] (JBIG)
	   fc: 33&l2A 	      PAGE SIZE: [letter]
	  101: 33&l255H	      PAPER SOURCE: [auto]
	  108: 33&l0M 	      MEDIA TYPE: [plain]
	  10d: 33&l0E 	      TOP MARGIN: [0]
	  112: 33*r9792S	      X RASTER: [9792,0x2640]
	  11a: 33*r6400T	      Y RASTER: [6400,0x1900]
	  122: 33&l0U
	  127: 33&l0Z
	  12c: 33*p200X	      X OFFSET: [200]
	  133: 33*p200Y	      Y OFFSET: [200]
	  13a: 33*r1A 	      [Page 1]
	  13f: 33*b20V	      [black]
				       DL = 0, D = 0, P = 1, - = 0, XY = 9792 x 6400
				       L0 = 128, MX = 0, MY = 0
				       Order   = 3  ILEAVE SMID
				       Options = 92  LRLTWO TPDON TPBON DPON
				       50 stripes, 0 layers, 1 planes
	  159: 33*b65536V	      JBIG data (first) [65536,0x10000]
				ff 02 c2 79 54 3e be e1 a0 de 08 9a b1 d2 c2 59
			       ... ae 88 ef a7 c7 96 d3 96 a6 d7 2c 06 38 75 22 44
	10162: 33*b26432W	      JBIG data (end) [26432,0x6740]
				0e 89 66 ce 01 41 41 41 41 41 41 41 41 41 41 41
			       ... 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
	168ab: 33*x3887138K	      BLACK DOTS: [3887138]
	168b6: 33*x58781662W	      BLACK WHITEDOTS: [58781662]
	168c2: 33*rC		      END PAGE
	168c6: 33&l0H 	      PAPER SOURCE: [eject]
	168cb: 33E		      RESET
	168cd: 33%-12345X

FILES

       /usr/bin/lavadecode

SEE ALSO

       foo2lava-wrapper(1), foo2lava(1)

AUTHOR

       Rick Richardson <rick.richardson@comcast.net>
       http://foo2lava.rkkda.com/
All times are GMT -4. The time now is 04:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy