Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing trailing zeros using sed
Top Forums Shell Programming and Scripting Removing trailing zeros using sed Post 302406780 by alister on Tuesday 23rd of March 2010 11:30:13 PM
Old 03-24-2010
Quote:
Originally Posted by daptal
i think it would remove 0's from each field

it shd be
Code:
sed 's/0000,/,/1' file

and that would still be wrong if the first field doesnot have any zero then it would remove from the subsequent fields
The 1 subsitution flag is redundant. By default, SED always subs only the first instance, unless you give it a number or g. There is no difference at all between "sed 's/0000,/,/1'" and "sed 's/0000,/,/'".

The original poster stated that the first column contains 4 trailing zeroes. My sed will remove them. If only some of the rows in the first column contain the trailing zeroes, then the mistake is in the original poster's problem statement for being imprecise. I assume that the problem is stated correctly and choose not to overcomplicate my proposed solution.

Regards,
Alister

---------- Post updated at 11:30 PM ---------- Previous update was at 11:25 PM ----------

However, if it did need to handle a first field that may not contain the four trailing zeroes, the correct sed would be:
Code:
sed 's/^\([^,]*\)0000,/\1,/' file

Smilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing leading zeros from a variable

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

2. Shell Programming and Scripting

How to delete trailing zeros from a variable

Hi All I want to delete trailing zeros from varible. ex: if variable value is 1234.567000 result as 1234.567 if variable has 1234.0000 result as 1234 if variable as abcd.fgh result as abcd.fgh Can somone give me a solution using awk? (16 Replies)
Discussion started by: Chandu2u
16 Replies

3. Shell Programming and Scripting

Removing Zeros in front of a number

Hi All, I would like to trim the following input. My condition is as long as there's a zero on the left of the number, remove the zeros. Can anybody help me by using sed or awk ? Eg: 0011 => change to => 11 0333 => change to => 333 4444 => No change => 4444 (13 Replies)
Discussion started by: Raynon
13 Replies

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

5. Shell Programming and Scripting

Removing trailing zeroes

So, I can't figure out how to do a previous question with printf, so I'm taking a different approach. Suppose I have a set of numbers: 1200,135.000000,12.30100,3212.3200,1.759403,,1230,101.101010,100.000000 I want to remove all trailing zeroes after the decimal, and, if it ends up orphaned,... (8 Replies)
Discussion started by: treesloth
8 Replies

6. Shell Programming and Scripting

Remove trailing zeros

Hi I have a simple request but can't find the answer. I want to remove trailing zeros, and in some cases the fullstops, from the input data. Example of input file: FR002_15.000_20.000 SD475_5.000_10.500 FG5647_12.250_15.500 BH2463_30.555_32.000 Desired output file would be: ... (10 Replies)
Discussion started by: theflamingmoe
10 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. 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

10. UNIX for Beginners Questions & Answers

Remove trailing zeros from numbers

Hi, I am trying to remove trailing zeros from numbers in a csv file. CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860 Expected Output : .5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86 Can you please help. Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies

LEARN ABOUT DEBIAN

nwbpset

NWBPSET(1)							      nwbpset								NWBPSET(1)

NAME

       nwbpset - Create a bindery property or set its value

SYNOPSIS

       nwbpset [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ]

DESCRIPTION

       nwbpset Reads a property specification from the standard input and creates and sets the corresponding property. The format is determined by
       the output of 'nwbpvalues -c'. nwbpset will hopefully become an important part of the bindery management  suite	of  ncpfs,  together  with
       'nwbpvalues -c'. See util/nwbpsecurity for an example.

       As another example, look at the following command line:

	 nwbpvalues -t 1 -o supervisor -p user_defaults -c |
	 sed '2s/.*/ME/'|
	 sed '3s/.*/LOGIN_CONTROL/'|
	 nwbpset

       With  this command, the property user_defaults of the user object 'supervisor' is copied into the property login_control of the user object
       'me'.

	 nwbpvalues -t 1 -o me -p login_control -c |
	 sed '9s/.*/ff/'|
	 nwbpset

       This command disables the user object me.

       Feel free to contribute other examples!

       nwbpset looks up the file $HOME/.nwclient to find a file server, a user name and possibly a password. See nwclient(5) for more information.
       Please note that the access permissions of $HOME/.nwclient MUST be 600 for security reasons.

OPTIONS

       -h
	  -h is used to print out a short help text.

       -S server
	  server is the name of the server you want to use.

       -U user
	  user is the user name to use for login.

       -P password
	  password  is	the  password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwbpset
	  prompts for a password.

       -n
	  -n should be given if no password is required for the login.

       -C
	  By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
	  this conversion by -C.

AUTHORS

       nwbpset was written by Volker Lendecke. See the Changes file of ncpfs for other contributors.

nwbpset 							     8/7/1996								NWBPSET(1)
All times are GMT -4. The time now is 09:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy