How to trim the zero's after decimal? Post: 302915540

Sponsored Content

Top Forums Shell Programming and Scripting How to trim the zero's after decimal? Post 302915540 by Corona688 on Wednesday 3rd of September 2014 04:16:17 PM

09-03-2014

Registered User

I thought all awk had -e. Oh well. Stripped it down to a faster program which doesn't need -e:

Code:

$ ls -lh filter.xml
-rw-r--r-- 1 user user 451M Sep  3 14:10 filter.xml

$ time awk 'NR==1 { next } NF==2 { sub(/[.]?0*$/ , "", $2) } { print RS $0 }' FS=">" RS="<" OFS=">" ORS="" filter.xml > out.xml

real    1m1.632s
user    0m59.813s
sys     0m1.787s

$ head -n 20 out.xml

<ACCRUED_INTEREST>0</ACCRUED_INTEREST>
  <BOOK_VALUE>0</BOOK_VALUE>
  <COMMIT_CURRENT>29250</COMMIT_CURRENT>
  <COMMIT_UNDISBURSED>29250</COMMIT_UNDISBURSED>
  <COST_OF_FUNDS>0.0049</COST_OF_FUNDS>
  <DATE_ORIGINATED>2013-05-15</DATE_ORIGINATED>
  <GOVT_GUARANTOR></GOVT_GUARANTOR>
  <INT_RATE>0.0518</INT_RATE>
<ACCRUED_INTEREST>0</ACCRUED_INTEREST>
  <BOOK_VALUE>0</BOOK_VALUE>
  <COMMIT_CURRENT>29250</COMMIT_CURRENT>
  <COMMIT_UNDISBURSED>29250</COMMIT_UNDISBURSED>
  <COST_OF_FUNDS>0.0049</COST_OF_FUNDS>
  <DATE_ORIGINATED>2013-05-15</DATE_ORIGINATED>
  <GOVT_GUARANTOR></GOVT_GUARANTOR>
  <INT_RATE>0.0518</INT_RATE>
<ACCRUED_INTEREST>0</ACCRUED_INTEREST>
  <BOOK_VALUE>0</BOOK_VALUE>
  <COMMIT_CURRENT>29250</COMMIT_CURRENT>
  <COMMIT_UNDISBURSED>29250</COMMIT_UNDISBURSED>

$

This User Gave Thanks to Corona688 For This Post:

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trim

Hello, I am passing a filename to a script to draw parameters from it. However, I want to use part of the filename as a parameter. The filename is transfer_ccf_3731_10.sh but I only need the 3731_10 part of it. Is this possible? Any help or suggestions would be appreciated! Regards, J.

2. Shell Programming and Scripting

Trim a new line

Okay, I am trying to make a bash script to get a certain domains IP address (my home ip). My home is on a DHCP lease from my ISP, so I cannot always trust the IP address to remain constant. This is what I have so far for it: alias ip-home="ping -c 1 example.com | grep 'PING' | cut -d'(' -f2 |...

3. UNIX for Dummies Questions & Answers

Decimal to BCD (Binary Coded Decimal)

Anybody please help me... Design an algorithm that accepts an input a decimal number and converts it into BCD (Binary Coded Decimal) representation. Also, draw its Flow Chart. This is a unix qn... plz post algorithm for that :confused:

4. Homework & Coursework Questions

Decimal to BCD (Binary Coded Decimal)

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Design an algorithm that accepts an input a decimal number and converts it into BCD (Binary...

5. UNIX for Dummies Questions & Answers

Convert hexa decimal to decimal

Hi, I want to convert two hexadecimal numbers to decimal using unix command line. 1cce446295197a9d6352f9f223a9b698 fc8f99ac06e88c4faf669cf366f60d I tried using `echo "ibase=16; $no |bc` printf '%x\n' "1cce446295197a9d6352f9f223a9b698" but it doesn't work for such big number it...

6. Programming

Urgent help needed.. C++ program to convert decimal to hexa decimal

Hi , seq can be 0...128 int windex = seq / 8; int bindex = seq % 8; unsigned char bitvalue = '\x01' << (7-bindex) ; bpv.bitmapvalue = bitvalue; This is the part of a program to convert decimal to bitmap value of hexadecimal. I want this to change to convert only to...

7. Shell Programming and Scripting

Decimal Padding in Decimal

Hi Experts, I have requirement to pad a decimal number that should have fixed length as 10. if number is 234.234 > 234.234000 if number is 12.4 > 12.4000000 if number is 3456.5678 > 3456.56780 from above example we can see that overall length is 10 and padding is being done right sided of...

8. UNIX for Dummies Questions & Answers

How to trim the decimal place for all the columns?

Dear all, I have a file call test.txt which has 2000 columns, 1000 rows. If I want to trim all the columns to 3 decimal places, how can I do it? I know how to use awk prinf to trim specic columns. But I don't know how to trim all the columns. Thank you. data sample: 0.976004565 9.34567845...

9. Shell Programming and Scripting

Sum the fields with 6 decimal places - getting only 2 decimal places as output

I used the below script to Sum up a field in a file based on some unique values. But the problem is when it is summing up the units, it is truncating to 2 decimals and not 6 decimals as in the input file (Input file has the units with up to 6 Decimals – Sample data below, when the units in the 2...

LEARN ABOUT DEBIAN

stag-autoschema

STAG-AUTOSCHEMA(1p)					User Contributed Perl Documentation				       STAG-AUTOSCHEMA(1p)

NAME

       stag-autoschema - writes the implicit stag-schema for a stag file

SYNOPSIS

	 stag-autoschema -w sxpr sample-data.xml

	 stag-autoschema -dtd sample-data.xml

DESCRIPTION

       Takes a stag compatible file (xml, sxpr, itext), or a file in any format plus a parser, and writes out the implicit underlying stag-schema

       stag-schema should look relatively self-explanatory.

       Here is an example stag-schema, shown in sxpr syntax:

	 (db
	  (person*
	   (name "s"
	   (address+
	    (address_type "s")
	    (street "s")
	    (street2? "s")
	    (city "s")
	    (zip? "s")))))

       The database db contains zero or more persons, each person has a mandatory name and at least one address.

       The cardinality mnemonics are as follows:

       +   1 or more

       ?   0 or one

       *   0 or more

       The default cardinality is 1

ARGUMENTS

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module

	   xml assumed as default

       -dtd
	   exports schema as DTD

       -w|writer FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module, OR DTD

	   The default is sxpr

	   note that stag schemas exported as xml will be invalid xml, due to the use of symbols *, +, ? in the node names

LIMITATIONS

       not event based - memory usage becomes exhorbitant on large files; prepare a small sample beforehand

perl v5.10.0							    2008-12-23						       STAG-AUTOSCHEMA(1p)

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trim

Discussion started by: JWilliams

2. Shell Programming and Scripting

Trim a new line

Discussion started by: tnanek

3. UNIX for Dummies Questions & Answers

Decimal to BCD (Binary Coded Decimal)

Discussion started by: caramba

4. Homework & Coursework Questions

Decimal to BCD (Binary Coded Decimal)

Discussion started by: caramba

5. UNIX for Dummies Questions & Answers

Convert hexa decimal to decimal

Discussion started by: sudhakar T

6. Programming

Urgent help needed.. C++ program to convert decimal to hexa decimal

Discussion started by: greenworld123

7. Shell Programming and Scripting

Decimal Padding in Decimal

Discussion started by: looney

8. UNIX for Dummies Questions & Answers

How to trim the decimal place for all the columns?

Discussion started by: forevertl

9. Shell Programming and Scripting

Sum the fields with 6 decimal places - getting only 2 decimal places as output

Discussion started by: brlsubbu

LEARN ABOUT DEBIAN

stag-autoschema