Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • February 7, 2018 at 6:22 am #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++;
		}
}
    February 8, 2018 at 1:05 am #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); 
				}
		}
    February 8, 2018 at 4:34 am #22844
    David
    Participant

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

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.