Thanks very much for the replys . I originally mucked around with a few pieces of code such as:
Code:
sed 's/\(\.[1-9][1-9]\)0/\1/' inputfile
and
Code:
awk '{gsub(/\.000/,"",$1); print $1}' inputfile
I couldn't get an overall solution. Couldn't get the sed code to work either, not sure what I was doing wrong. Anyway, will test solutions tomorrow when at work. Thanks again for your input.
Hello all, I have a list of reports for stores that are numbered like:
s001845,s000022,s198490,s020048,s002385
however the users are displaying the reports as:
1845,22,198490,20048,2385
It isn't real critical but I would like to associate them so they are the same. And since the users are... (2 Replies)
Hi all,
Can anybody help me out to write a program in perl to remove O and preceeding zeros.
for eg input is O0000123089 - output 123089
Thanks
Mahalakshmi.A (10 Replies)
Hi,
I have a file like this
(ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa
------------------------------------------------------------
2007-06-30 00:00:00
I have a requirement where i need just the date.
When i do: tail -1... (2 Replies)
Hello, I am trying to write a script that will calculate the amount of data remaining in a storage volume. I'm running Tru64 Unix version 5.1B patch kit 6. The script is being run against an AdvFS domain. I am programming in Korn Shell version M-11/16/88f.
The basic idea is that I want to run df... (3 Replies)
Hi All
I want to delete trailing zeros from varible.
ex:
if variable value is 1234.567000 result as 1234.567
if variable has 1234.0000 result as 1234
if variable as abcd.fgh result as abcd.fgh
Can somone give me a solution using awk? (16 Replies)
Hello All,
I have a csv file with 3 columns. The file which looks like this
47850000,100,233
23560000,10000,456
78650000,560000,54
34000000,3456,3
The first column has 4 trailing zeros. I have to remove 4 trailing zeroes from 1st field. The output file should appear as follows.
... (12 Replies)
Hi
I am trying to remove trailing space from a string.
value=${value%% }
It is not working. What might be the issue with the above snippet. (7 Replies)
I have some strings such as
ABC1
ABC2
TYFASDD12
They will only have letters and numbers. In each case I want to remove the last digit? The lengths will vary. So a hard coded substr won't work. What do I do?
if it doesn't end in a number, I don't want to remove any characters. (6 Replies)
Hi,
I am trying to remove trailing zeros from numbers in a csv file.
CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860
Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86
Can you please help.
Thanks. (11 Replies)
Discussion started by: manubatham20
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)
09-05-2012
. I originally mucked around with a few pieces of code such as: