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 the first part of a if statement then deal with the remainder but that i think is quite messy as there may be many of them
Ideas?
My input to check is like this file below and trying to process with this code snipopet
File:
Thanks
Ken
Last edited by Scott; 09-26-2013 at 08:58 AM..
Reason: Removed attachment; not necessary for such a small file
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)
Hello Gurus,
Quick question. I have a file with the following records:
A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~
A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~
A~000000000000772000~SLP ~99991231~20100701~118.08~USD~CS~
I wold like to do the following:
1. Add... (1 Reply)
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)
Hello,
I have a pipe separated file with two major lines. One is header and another is detail line. Header starts with H and Detail start with D.
Sample Content:
H|123456|Joes Watson|UK|4/5/2016|12/5/2016|3456|HC|NW||||||
D|123456|Joes... (13 Replies)
Hi All,
I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.
Is there any... (11 Replies)
Discussion started by: karthik adiga
11 Replies
LEARN ABOUT DEBIAN
excel::template::container::keepleadingzeros
Excel::Template::Container::KeepLeadingZeros(3pm) User Contributed Perl Documentation Excel::Template::Container::KeepLeadingZeros(3pm)NAME
Excel::Template::Container::KeepLeadingZeros - Excel::Template::Container::KeepLeadingZeros
PURPOSE
To set the keep_leading_zeros flag for the surrounding worksheet or any worksheets that might be contained within this node.
NODE NAME
KEEP_LEADING_ZEROS
INHERITANCE
CONTAINER
ATTRIBUTES
None
CHILDREN
None
EFFECTS
Alters how leading zeros are interpreted by Spreadsheet::WriteExcel.
DEPENDENCIES
None
USAGE
<worksheet>
... Cells here will NOT have leading-zeros preserved
<keep_leading_zeros>
... Cells here will have leading-zeros preserved
</keep_leading_zeros>
... Cells here will NOT have leading-zeros preserved
</worksheet>
<keep_leading_zeros>
<worksheet>
... Cells here will have leading-zeros preserved
</worksheet>
<worksheet>
... Cells here will have leading-zeros preserved
</worksheet>
</keep_leading_zeros>
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
CELL, Spreadsheet::WriteExcel
perl v5.14.2 2010-06-17 Excel::Template::Container::KeepLeadingZeros(3pm)