Sponsored Content
Top Forums Shell Programming and Scripting Removing leading zeros for a decimal column Post 302499933 by Shell_Life on Friday 25th of February 2011 05:44:55 PM
Old 02-25-2011
Using sed:
Code:
sed -e 's/, *0*\./,0./' -e 's/, *0.*\([1-9]\)/,\1/' inp_file

 

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
STRPTIME(3)						   BSD Library Functions Manual 					       STRPTIME(3)

NAME
strptime -- converts a character string to a time value LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <time.h> char * strptime(const char * restrict buf, const char * restrict format, struct tm * restrict tm); DESCRIPTION
The strptime() function converts the character string pointed to by buf to values which are stored in the tm structure pointed to by tm, using the format specified by format. The format string consists of zero or more conversion specifications, whitespace characters as defined by isspace(), and ordinary characters. All ordinary characters in format are compared directly against the corresponding characters in buf; comparisons which fail will cause strptime() to fail. Whitespace characters in format match any number of whitespace characters in buf, including none. A conversion specification consists of a percent sign '%' followed by one or two conversion characters which specify the replacement required. There must be white-space or other non-alphanumeric characters between any two conversion specifications. Conversion of alphanumeric strings (such as month and weekday names) is done without regard to case. Conversion specifications which cannot be matched will cause strptime() to fail. The LC_TIME category defines the locale values for the conversion specifications. The following conversion specifications are supported: %a the day of week, using the locale's weekday names; either the abbreviated or full name may be specified. %A the same as %a. %b the month, using the locale's month names; either the abbreviated or full name may be specified. %B the same as %b. %c the date and time, using the locale's date and time format. %C the century number [0,99]; leading zeros are permitted but not required. This conversion should be used in conjunction with the %y conversion. %d the day of month [1,31]; leading zeros are permitted but not required. %D the date as %m/%d/%y. %e the same as %d. %F the date as %Y-%m-%d (the ISO 8601 date format). %g the year corresponding to the ISO week number, without the century. (A NetBSD extension.) %G the year corresponding to the ISO week number, with the century. (A NetBSD extension.) %h the same as %b. %H the hour (24-hour clock) [0,23]; leading zeros are permitted but not required. %I the hour (12-hour clock) [1,12]; leading zeros are permitted but not required. %j the day number of the year [1,366]; leading zeros are permitted but not required. %k the same as %H. %l the same as %I. %m the month number [1,12]; leading zeros are permitted but not required. %M the minute [0,59]; leading zeros are permitted but not required. %n any white-space, including none. %p the locale's equivalent of a.m. or p.m. %r the time (12-hour clock) with %p, using the locale's time format. %R the time as %H:%M. %S the seconds [0,61]; leading zeros are permitted but not required. %s the number of seconds since the Epoch, UTC (see mktime(3)). (A NetBSD extension.) %t any white-space, including none. %T the time as %H:%M:%S. %u the day of the week as a decimal number, where Monday = 1. (A NetBSD extension.) %U the week number of the year (Sunday as the first day of the week) as a decimal number [0,53]; leading zeros are permitted but not required. All days in a year preceding the first Sunday are considered to be in week 0. %V the ISO 8601:1988 week number as a decimal number. If the week (starting on Monday) that contains January 1 has more than three days in the new year, then it is considered the first week of the year. If it has fewer than four days in the new year, then it is consid- ered the last week of the previous year. Weeks are numbered from 1 to 53. (A NetBSD extension.) %w the weekday as a decimal number [0,6], with 0 representing Sunday; leading zeros are permitted but not required. %W the week number of the year (Monday as the first day of the week) as a decimal number [0,53]; leading zeros are permitted but not required. All days in a year preceding the first Monday are considered to be in week 0. %x the date, using the locale's date format. %X the time, using the locale's time format. %y the year within the 20th century [69,99] or the 21st century [0,68]; leading zeros are permitted but not required. If specified in conjunction with %C, specifies the year [0,99] within that century. %Y the year, including the century (i.e., 1996). %z an ISO 8601 or RFC-2822 timezone specification. This is one of the following: the offset from Coordinated Universal Time ('UTC') spec- ified as: ``[+-]hhmm'', ``[+-]hh:mm'', or ``[+-]hh''; 'UTC' specified as: ``GMT'' ('Greenwich Mean Time'), ``UT'' ('Universal Time'), or ``Z'' ('Zulu Time'); a three character US timezone specified as: ``EDT'', ``EST'', ``CDT'', ``CST'', ``MDT'', ``MST'', ``PDT'', or ``PST'', with the first letter standing for 'Eastern' (``E''), 'Central' (``C''), 'Mountain' (``M'') or 'Pacific' (``P''), and the sec- ond letter standing for 'Daylight' (``D'' or summer) time or 'Standard' (``S'') time; a single letter military timezone specified as: ``A'' through ``I'' and ``K'' through ``Y''. (A NetBSD extension.) %Z timezone name or no characters when time zone information is unavailable. (A NetBSD extension.) %% matches a literal `%'. No argument is converted. Modified conversion specifications For compatibility, certain conversion specifications can be modified by the E and O modifier characters to indicate that an alternative for- mat or specification should be used rather than the one normally used by the unmodified conversion specification. As there are currently neither alternative formats nor specifications supported by the system, the behavior will be as if the unmodified conversion specification were used. Case is ignored when matching string items in buf, such as month and weekday names. RETURN VALUES
If successful, the strptime() function returns a pointer to the character following the last character parsed. Otherwise, a NULL pointer is returned. SEE ALSO
ctime(3), isspace(3), localtime(3), strftime(3), tm(3) STANDARDS
The strptime() function conforms to X/Open Portability Guide Issue 4 (``XPG4''). BUGS
The %Z format specifier only accepts timezone abbreviations of the local timezone, or the value ``GMT''. This limitation is caused by the ambiguity of overloaded timezone abbreviations, for example EST is both Eastern Standard Time and Eastern Australia Summer Time. BSD
April 12, 2011 BSD
All times are GMT -4. The time now is 03:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy