Thread: Padding with zeros

Could you post the whole function you have now?

Another cup of tea and I should be awake enough to have a look through it....

Code:

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

			
			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;
			}
			
			if(neg) 
			{	
									
				sNumber = '-' + sNumber ;
			}
			return sNumber.substr(0, vlLength);
				
		}

I got this to work for me:-

Code:

function msPadNumber(vvNumber, vlLength, vlDPs)
  {
   var sNumber = '';
   var neg = false;
   
   try
   {
    sNumber = vvNumber(0).text;
   }
   catch(e)
   {
    sNumber = vvNumber.toString();
   }
   
   
   if(sNumber.search(/-/)!=-1)
   {
    sNumber = sNumber.replace(/-/,'');
    neg=true;
   }  
   
   if(sNumber.indexOf('.') != -1)
   {
    var lDPs;
    if(neg) {
     lDPs = sNumber.length - sNumber.indexOf('.') - 2;
    }else{
     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;
   }
   
   if(neg) 
   { 
         
    sNumber = '-' + sNumber ;
   }
   return sNumber.substr(0, vlLength);
    
  }

it seems working.Thanks a lot.

Originally Posted by guddu

it seems working.Thanks a lot.

I wasn't sure if it was dropping a 0 off the front if it's negative or if that was right...