truncating leading zeros of a column in a file

nvuradi · #1 (**permalink**) 08-30-2007

Hi

I have a file in which I have 5 columns which are delimited by “|” as shown

ABC|12|YAK|METRIC|000000019.5

XYZ|10|ABX|META|000000002.5

Now my requirement is to take the last column trim the leading zero’s for that column values and write back to the same file in the same order.

Any suggestions regarding the same?
is der any file utility do the same?

Thanks
Narendar

ghostdog74 · #2 (**permalink**) 08-30-2007

Code:

# awk  'BEGIN{FS=OFS="|"}{$NF=$NF+0}1' file
ABC|12|YAK|METRIC|19.5
XYZ|10|ABX|META|2.5

nvuradi · #3 (**permalink**) 08-30-2007

hi i am getting the following error when i used the awk command

awk 'BEGIN{FS=OFS="|"}{$NF=$NF+0} 1' $filename
Error:
awk: syntax error near line 1
awk: bailing out near line 1

if possible can you explain what is this awk command doing here?

Thanks
Narendar

ghostdog74 · #4 (**permalink**) 08-30-2007

Quote:

Originally Posted by nvuradi

hi i am getting the following error when i used the awk command

awk 'BEGIN{FS=OFS="|"}{$NF=$NF+0} 1' $filename
Error:
awk: syntax error near line 1
awk: bailing out near line 1

if possible can you explain what is this awk command doing here?

Thanks
Narendar

change "1" to {print} .
read the man page for the definition of NF. I am bad at explaining, maybe someone is kind enough to help out.

namishtiwari · #5 (**permalink**) 08-30-2007

Hi,
Try this code,its not tested though..

#!/bin/ksh
cat test19 | for i in file
do
cut -d"|" -f5 | tr -s "00" $i
done

namishtiwari · #6 (**permalink**) 08-30-2007

Quote:

Originally Posted by nvuradi

hi i am getting the following error when i used the awk command

awk 'BEGIN{FS=OFS="|"}{$NF=$NF+0} 1' $filename
Error:
awk: syntax error near line 1
awk: bailing out near line 1

if possible can you explain what is this awk command doing here?

Thanks
Narendar

change 1 to {print},its working perfectly fine.

nvuradi · #7 (**permalink**) 08-30-2007

Quote:

Originally Posted by namishtiwari

change 1 to {print},its working perfectly fine.

yeah its printing the contents ..but i want to write it to same file....

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Triml leading zeros in unix	kingofprussia	UNIX for Dummies Questions & Answers	7	08-07-2008 05:04 AM
Help needed in padding leading zeros	jakSun8	Shell Programming and Scripting	12	07-02-2008 07:41 PM
Removing leading zeros from a variable	toshidas2000	Shell Programming and Scripting	6	02-27-2008 01:13 PM
how to retain leading zeros	Manish Jha	Shell Programming and Scripting	3	11-09-2006 05:59 PM
Leading zeros	wtofu	Shell Programming and Scripting	1	09-16-2006 02:52 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: