Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing leading zeros for a decimal column
Top Forums Shell Programming and Scripting Removing leading zeros for a decimal column Post 302499940 by vgersh99 on Friday 25th of February 2011 06:18:01 PM
Old 02-25-2011
Code:
bash-2.05$ cat mar.txt
,,,,,6630140,XXXXXXXXXXXXXXX, 0020.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0010.00,USA
,,,,,6630150,XXXXXXXXXXXXXXX(xyz), 1300.00,USA
bash-2.05$
bash-2.05$
bash-2.05$ nawk -F, '$8=sprintf("%.2f", $8)' OFS=, mar.txt
,,,,,6630140,XXXXXXXXXXXXXXX,20.00,USA
,,,,,6630150,XXXXXXXXXXXXXXXL (xyz,10.00,USA
,,,,,6630150,XXXXXXXXXXXXXXX(xyz),1300.00,USA

This User Gave Thanks to vgersh99 For This Post:
marpadga18
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Leading zeros

How to insert leading zeros into a left-justisfied zip code? e.g. Zip code is written as 60320 which is left-justified to make it be read as 0060320. We have to move it to right-justifiable then insert 2 leading zeros into it... ;) (1 Reply)
Discussion started by: wtofu
1 Replies

2. Shell Programming and Scripting

how to retain leading zeros

Hi All, I am working with a fixed width file Forrmat. C1 Number (10,3) C2 Number (10,3) e.g. c1= 0000000100.000 c2= 0000000020.000 0000000100.0000000000020.000 I have to perform c1 - c2 . i.e. I want answer to be 0000000080.000. but I am loosing the leading zeros( only getting... (3 Replies)
Discussion started by: Manish Jha
3 Replies

3. Shell Programming and Scripting

truncating leading zeros of a column in a file

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... (7 Replies)
Discussion started by: nvuradi
7 Replies

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

5. Shell Programming and Scripting

Help needed in padding leading zeros

Hi all, I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16. Example: cat tmp.txt 502455 50255 5026 5027 5028 Output 0000000000502455 0000000000050255 0000000000005026 0000000000005027 0000000000005028 Any... (12 Replies)
Discussion started by: jakSun8
12 Replies

6. UNIX for Dummies Questions & Answers

Triml leading zeros in unix

Hi All, How does one trim leading zero's in unix Thanks KP. (7 Replies)
Discussion started by: kingofprussia
7 Replies

7. Shell Programming and Scripting

Help with adding leading zeros to a filename

Hi i need help in adding leading zero to filenames e.g file name in my folder are 1_234sd.txt 23_234sd.txt the output i need is 001_234sd.txt 023_234sd.txt can i do this shell scripting please help (2 Replies)
Discussion started by: rsmpk
2 Replies

8. Shell Programming and Scripting

Numbers with leading zeros

Hi, i have a variable which conatins values like 00001,0003,00067,00459. I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459. Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
Discussion started by: arijitsaha
5 Replies

9. Shell Programming and Scripting

Help deleting leading zeros in a file

I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies

10. Shell Programming and Scripting

Fixed with file- removing leading zeros and adding the space

Hi All, i have a fixed width file , where each line is 3200 length. File: 1ABC 1111 2222 3333 000012341 1001 2ABC 1111 2222 3333 000012342 1002 3ABC 1111 2222 3333 000112343 1003 1DEF 5555 4444 9696 000012344 1004 2DEF 5555 2323 8686 000012345 1005 3DEF 5555 1212 7676 000012346 1006 ... (1 Reply)
Discussion started by: mechvijays
1 Replies

LEARN ABOUT MOJAVE

datetime::locale::dz_bt5.18

DateTime::Locale::dz_BT(3)				User Contributed Perl Documentation				DateTime::Locale::dz_BT(3)

NAME

       DateTime::Locale::dz_BT

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'dz_BT' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Dzongkha Bhutan.

DATA

       This locale inherits from the DateTime::Locale::dz locale.

       It contains the following data.

   Days
       Wide (format)

	 XXXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Abbreviated (format)

	 XXXX
	 XXXX
	 XXXX
	 XXXX
	 XXXXX
	 XXX
	 XXX

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 XXXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXXX
	 XXXXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Abbreviated (stand-alone)

	 XXXX
	 XXXX
	 XXXX
	 XXXX
	 XXXXX
	 XXX
	 XXX

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX

       Abbreviated (format)

	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX XX
	 XXX XX
	 XXX XX

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXXXXXXX

       Abbreviated (stand-alone)

	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX X
	 XXX XX
	 XXX XX
	 XXX XX

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX

       Abbreviated (format)

	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 XXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXXX
	 XXXXXXXXXXXXXX

       Abbreviated (stand-alone)

	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX
	 XXXXXXXXX

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BCE
	 CE

       Abbreviated

	 BCE
	 CE

       Narrow

	 BCE
	 CE

   Date Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15

       Long

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15

       Medium

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15

       Short

	  2008-02-05T18:30:30 = 2008-02-05
	  1995-12-22T09:05:02 = 1995-12-22
	 -0010-09-15T04:44:23 = -010-09-15

       Default

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = XXXXXXX6:30:30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXX9:05:02 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXX4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXX

       Default

	  2008-02-05T18:30:30 = XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Long

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXXXXXXXXXXXXXXX XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXXXXXXXXXXXXXXXXXXX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXXXXXXXXXXXXXX XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

       Medium

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05 XXXXXXX6:30:30 XXXXXX
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22 XXXXXXX9:05:02 XXXXX
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15 XXXXXXX4:44:23 XXXXX

       Short

	  2008-02-05T18:30:30 = 2008-02-05 XXXXXXX 6 XXXXXX 30 XXXXXX
	  1995-12-22T09:05:02 = 1995-12-22 XXXXXXX 9 XXXXXX 05 XXXXX
	 -0010-09-15T04:44:23 = -010-09-15 XXXXXXX 4 XXXXXX 44 XXXXX

       Default

	  2008-02-05T18:30:30 = XXXXXXXX2008 XXX XXX X XXXX 05 XXXXXXX 6 XXXXXX 30 XXXXXXX 30 XXXXXX UTC
	  1995-12-22T09:05:02 = XXXXXXXX1995 XXX XXX XX XXXX 22 XXXXXXX 9 XXXXXX 05 XXXXXXX 02 XXXXX UTC
	 -0010-09-15T04:44:23 = XXXXXXXX-10 XXX XXX X XXXX 15 XXXXXXX 4 XXXXXX 44 XXXXXXX 23 XXXXX UTC

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 XXXX
	  1995-12-22T09:05:02 = 22 XXXXX
	 -0010-09-15T04:44:23 = 15 XXX

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 XXXXXX
	  1995-12-22T09:05:02 = 9:05 XXXXX
	 -0010-09-15T04:44:23 = 4:44 XXXXX

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 XXXXXX
	  1995-12-22T09:05:02 = 9:05:02 XXXXX
	 -0010-09-15T04:44:23 = 4:44:23 XXXXX

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = XXXX, 2-5
	  1995-12-22T09:05:02 = XXXXX, 12-22
	 -0010-09-15T04:44:23 = XXX, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = XXX X
	  1995-12-22T09:05:02 = XXX XX
	 -0010-09-15T04:44:23 = XXX X

       MMMd (MMM d)

	  2008-02-05T18:30:30 = XXX X 5
	  1995-12-22T09:05:02 = XXX XX 22
	 -0010-09-15T04:44:23 = XXX X 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = XXXX XXX X 5
	  1995-12-22T09:05:02 = XXXXX XXX XX 22
	 -0010-09-15T04:44:23 = XXX XXX X 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = XXXXXXXXXXXXXXXX 5
	  1995-12-22T09:05:02 = XXXXXXXXXXXXXXXXXXXX 22
	 -0010-09-15T04:44:23 = XXXXXXXXXXXXXXX 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = XXXX XXXXXXXXXXXXXXXX 5
	  1995-12-22T09:05:02 = XXXXX XXXXXXXXXXXXXXXXXXXX 22
	 -0010-09-15T04:44:23 = XXX XXXXXXXXXXXXXXX 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = XXXX, 2008-2-5
	  1995-12-22T09:05:02 = XXXXX, 1995-12-22
	 -0010-09-15T04:44:23 = XXX, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 XXX X
	  1995-12-22T09:05:02 = 1995 XXX XX
	 -0010-09-15T04:44:23 = -10 XXX X

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = XXXX, 2008 XXX X 5
	  1995-12-22T09:05:02 = XXXXX, 1995 XXX XX 22
	 -0010-09-15T04:44:23 = XXX, -10 XXX X 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 XXXXXXXXXXXXXXXX
	  1995-12-22T09:05:02 = 1995 XXXXXXXXXXXXXXXXXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXXXXXXXXXXX

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 XXXXXXXXX
	  1995-12-22T09:05:02 = 1995 XXXXXXXXX
	 -0010-09-15T04:44:23 = -10 XXXXXXXXX

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       No

       Local first day of the week

       XXXXXXXXXXXX

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						DateTime::Locale::dz_BT(3)
All times are GMT -4. The time now is 12:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy