removing leading zeros for a decimal column in a file which has string & decimal values
My file contains 9 columns. Out 9 columns, 8th column contains the decimal/integer values.
In my requirement, i just need to remove the leading zero from the integer column. say for example
I tried the below command in unix. But, it didn't work for my requirement.
It works well for 0020 or 0010. The above command converts 0020 to 20 and 0010 to 10. But, when there is a fraction in the number, the above one is not working.
Any suggestions?
Thanks,
N
Last edited by radoulov; 02-25-2011 at 06:06 PM..
Reason: Code tags, please!
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)
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)
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)
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)
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)
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)
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)
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 HPUX
strtoimax
strtoimax(3C)strtoimax(3C)NAME
strtoimax(), strtoumax() - convert string to integer
SYNOPSIS DESCRIPTION
or converts the character string pointed to by str to or representation, respectively. The string is scanned up to the first character
inconsistent with the base. Leading ``white-space'' characters (as defined by in ctype(3C)) are ignored. If no conversion can take place,
zero is returned.
If base is greater than or equal to 2 and less than or equal to 36, it is used as the base for conversion. After an optional leading sign,
leading zeros are ignored, and or is ignored if base is 16.
If base is zero, the string itself determines the base as follows: after an optional leading sign, a leading zero indicates octal conver-
sion; a leading or indicates hexadecimal conversion. Otherwise, decimal conversion is used.
If the value of ptr is not a pointer to the character terminating the scan is returned in the location pointed to by ptr. If no integer
can be formed, the location pointed to by ptr is set to str, and zero is returned.
RETURN VALUE
Upon successful completion, all functions return the converted value, if any.
If the correct value would cause overflow:
returns or (according to the sign of the value), and sets to
returns and sets to
For all other errors, zero is returned and is set to indicate the error.
ERRORS
and fail and is set, if any of the following conditions are encountered:
The value of base is not supported.
The value to be returned would have caused overflow.
AUTHOR
and were developed by HP.
SEE ALSO ctype(3C), strtod(3C), strtol(3C), scanf(3S), thread_safety(5).
STANDARDS CONFORMANCE strtoimax(3C)