Thread: Padding with zeros

hi
below is javascript function used to padd no of zeros.this is working for positive nos but in case of negative nos not working.

let me explain
suppose no is like this 47.51
and i m calling function like this javascript:msPadNumber(47.51, 12, 2)
i m getting output like this 000000004751 which is correct.

but suppose i call negative no like this javascript:msPadNumber(-47.51, 12, 2)
i m getting output like this 0000000-4751. but i want output like this
-00000004751.

hope it make some sense.
how to get this?

Code:

function msPadNumber(vvNumber, vlLength, vlDPs)
{
	var sNumber = '';
	
	try
	{
		sNumber = vvNumber(0).text;
	}
	catch(e)
	{
		sNumber = vvNumber.toString();
	}
	
	if(sNumber.indexOf('.') != -1)
	{
		var lDPs = sNumber.length - sNumber.indexOf('.') - 1;
		
		if(lDPs > vlDPs)
		{
			sNumber = sNumber.substr(0, sNumber.length + vlDPs - lDPs);
			vlDPs = 0;
		}
		else
		{
			vlDPs -= lDPs;
		} 
	}
	
	for(var i=0; i<vlDPs; i++)
	{
		sNumber += '0';
	}
	
	sNumber = sNumber.replace('.','');
	
	while(sNumber.length < vlLength)
	{
		sNumber = '0' + sNumber;
	}
	
	return sNumber.substr(0, vlLength);
		
}

use an if statement to see if the number is less than zero, then remove the negative sign, pad your number and add the negative sign back in.

how to remove and add sign back in javascript?

Something like this:-

Code:

var neg = false;
if(sNumber.search(/-/)!=-1){
sNumber.replace(/-/,'');
neg=true;
}
 
 
if(neg) sNumber = '-';

hi @RR

for time being i used only this part of code in mine

Code:

try
			{
				sNumber = vvNumber(0).text;
			}
			catch(e)
			{
				sNumber = vvNumber.toString();
			}
			
			var neg = false;
			if(sNumber.search(/-/)!=-1){
			sNumber.replace(/-/,'');
			neg=true;
			}
-------Rest of code

so that the final output will not contain - sign.but still i m getting - sign in my output

ok
this should be like this

Code:

var neg = false;
if(sNumber.search(/-/)!=-1){
sNumber = sNumber.replace(/-/,'');
neg=true;
}

Originally Posted by guddu

ok
this should be like this

Code:

var neg = false;
if(sNumber.search(/-/)!=-1){
sNumber = sNumber.replace(/-/,'');
neg=true;
}

Ah, yes...Sorry about that...Good spot

hi
Guys there is issue with this code on live.
for this example
suppose I call negative no like this javascript:msPadNumber(-47.51, 12, 2)
I want output like this
-00000004751.

but currently i m getting output like this
-00000000475

the negative sign is incorrectly causing the last digit to be dropped.so 1 is missing in my output

It's a bit early in the morning for me to work this through, but I think it's to do with this line:-

Code:

var lDPs = sNumber.length - sNumber.indexOf('.') - 1;

indexOf starts at 0 so I think the positioning will be 1 to the left of the position you think it's at and combined with the length which would start at 1, it's pushing it one place to the left.

what should I do now?