Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #22842

    David
    Participant

    I’d like to use a macro to replace the number located at the beginning of a row with a sequential number. For example,
    Original Format:
    1.TestA
    3.TestB
    20.TestC
    2.TestD
    Wanted Format:
    01.TestA
    02.TestB
    03.TestC
    04.TestD

    10.TestN
    But my macro can only get the following result:
    1.TestA
    2.TestB
    3.TestC

    10.TestN
    Would you please give me some tips? Thanks!

    
    function Renumber_FirstNo1()
    {
    	redraw = false;
    	if( document.selection.IsEmpty ) 
    		{document.selection.StartOfDocument();
                            var count = prompt( "Type the Start Number please:", "1" );
    			var strFind = "^\\d+";
    			while(document.selection.Replace(strFind, count, eeFindReplaceRegExp | eeFindNext)) count++;}
    	else
    		{var count = prompt( "Type the Start Number please:", "1" );
    		var strFind = "";
    		while(document.selection.Replace(strFind + "^\\d+", strFind + count, eeFindReplaceRegExp | eeFindNext | eeFindReplaceSelOnly)) count++;
    		}
    }
    
    #22843

    Stefan
    Participant

    You have to add the zero’s padding yourself.
     

    For example (a fix-two-digits result):

    
    	redraw = false;
    	if( document.selection.IsEmpty ) 
    		{
    			document.selection.StartOfDocument();
    			var iCount = prompt("Type the Start Number please:", "1");
    			var strFind = "^\\d+";
    			while(document.selection.Replace(strFind, iCount, eeFindReplaceRegExp | eeFindNext))
    				{
    					iCount++; 
    					iCount = ("0"+iCount).slice(-2); 
    				}
    		}
    

     
     
    -or, more flexible (type in ‘1’, or ’01’, or ‘001’, or ‘0001’, …. to set the wanted amount of zeros:
     

    
    	redraw = false;
    	if( document.selection.IsEmpty ) 
    		{
    			document.selection.StartOfDocument();
    			var iCount = prompt("Start Number (incl. leading zero(s):", "1");
    			var iCountLen = iCount.toString().length;
    			var strFind = "^\\d+";
    			while(document.selection.Replace(strFind, iCount, eeFindReplaceRegExp | eeFindNext))
    				{
    					iCount++; 
    					iCount = ("00000000"+iCount).slice(-iCountLen); 
    				}
    		}
    
    
    #22844

    David
    Participant

    Hello, Stefan. It works very well. Thank you!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.