What?
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...
...
So going through the forums you may find the following example:
string padWithLeadingZeros(int finalStringLength, int startingNumber)
{
return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ...
... (padded with zeros)
How?
So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query:
SELECT
RIGHT('000' + CAST(e.ID AS VARCHAR), ...
... zeros
-- "00000" because we don't expect strings to exceed 5 characters.
The Oracle Error Value
Returning just the 5 digits of the oracle error code without the minus/hyphen in front.
=IIF(
Fields!ERROR_CODE.Value="SUCCESS", ...
... a solution that was FREE but was good enough to replace RokDownloads, Phoca Download, or Remository. Something like "JoomBug" but this was commercial and reviews weren't positive. "Zerosoft ZJ Downloads" ...
... with leading zeros (for sorting purposes - eg. so 10 is not before 2)
Store both the formatted count and the value of column1.table in the next array entry
Reverse this array
Display ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.