Remove leading zeroes in 2nd field using sed


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove leading zeroes in 2nd field using sed
# 1  
Old 10-04-2010
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:
Code:
2010-01-01|123|1|1000|2000|500|1500|600|700
2010-01-01|0456|1|1000|2000|500|1500|600|700


After:
Code:
2010-01-01|123|1|1000|2000|500|1500|600|700
2010-01-01|456|1|1000|2000|500|1500|600|700

Any help will be greatly appreciated.

Thank you.

Last edited by Scott; 10-04-2010 at 01:36 PM.. Reason: Before: No code tags; After: code tags
# 2  
Old 10-04-2010
Code:
sed 's/\([^|]*|\)0*/\1/' infile >outfile

# 3  
Old 10-04-2010
Hi, you need to fix it to the beginning of the line, otherwise it may alter other fields:
Code:
sed 's/^\([^|]*|\)0*/\1/' infile


Last edited by Scrutinizer; 10-04-2010 at 12:58 PM..
# 4  
Old 10-04-2010
Code:
$ ruby -F"\|" -ane '$F[1].gsub!(/^\s*0+/,"");print $F.join("|")' file

# 5  
Old 10-04-2010
Thanks, that's right, Scrutinizer. Though I did not find any difference between with and without fixation, no matter what I tried.
This User Gave Thanks to hergp For This Post:
# 6  
Old 10-04-2010
Quote:
Originally Posted by hergp
Thanks, that's right, Scrutinizer. Though I did not find any difference between with and without fixation, no matter what I tried.
It isn't necessary IMHO, this part:
Code:
\([^|]*|\)

selects the line until the first "|":
Code:
2010-01-01|

# 7  
Old 10-04-2010
The following will handle any leading zeroes (if any) after the first "|" in the line. Any other fields with leading zeroes are not modified.
Code:
sed 's/|0*/|/'

Regards,
Alister
These 3 Users Gave Thanks to alister For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

[Solved] How remove leading whitespace from xml (sed /awk?)

Hi again I have an xml file and want to remove the leading white space as it causes me issues later in my script I see sed is possible but cant seem to get it to work I tried sed 's/^ *//' file.xml output <xn:VsDataContainer id="1U104799" modifier="update"> ... (10 Replies)
Discussion started by: aniquebmx
10 Replies

2. Shell Programming and Scripting

sed to work on 2nd field only

I have a requirement to replace "\" with "/" in only the 2nd field of the input file which has 2 fields. The field delimiter is "|" Sample records from input file: 1\23|\tmp\user mn\wer|\home\temp Expected output: 1\23|/tmp/user mn\wer|/home/temp I used sed 's/\\/\//g' ... (2 Replies)
Discussion started by: krishmaths
2 Replies

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

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

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

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 over writes my original file (using sed to remove leading spaces)

Hello and thx for reading this I'm using sed to remove only the leading spaces in a file bash-280R# cat foofile some text some text some text some text some text bash-280R# bash-280R# sed 's/^ *//' foofile > foofile.use bash-280R# cat foofile.use some text some text some text... (6 Replies)
Discussion started by: laser
6 Replies

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

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

10. Shell Programming and Scripting

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... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies
Login or Register to Ask a Question