VBScript Loop Counter

Question

I need a loop counter that starts at 001 and continues until the scripts reaches the end of the recordset. The counter needs to be displayed as:

etc...

It needs to be a fixed length of three characters and the number will never exceed 999.

Everytime I try this the counter ignores the zeros at the start and just counts like:

etc...

Can anybody help?

Ekkehard.Horner · Accepted Answer · 2013-10-09 14:10:56Z

3

Or:

>> For Each i In Array(0, 1, 9, 11, 88, 101)
>>     WScript.Echo Right(1000 + i, 3)
>> Next
>>
000
001
009
011
088
101
>>

answered Oct 9, 2013 at 14:10

Ekkehard.Horner

38.8k2 gold badges50 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ServerGuy · Accepted Answer · 2013-10-09 12:06:33Z

1

There is probably an easier way to do this, but here is what I would do:

for i = 1 to 999
    if i > 99 then
        wscript.echo i
    elseif i > 9 then
        wscript.echo "0" & i
    else
        wscript.echo "00" & i
    end if
next

answered Oct 9, 2013 at 12:06

ServerGuy

5653 silver badges11 bronze badges

1 Comment

user1847961 Over a year ago

Thanks, I've basically done the same as your suggestion and it works fine now.

Collectives™ on Stack Overflow

VBScript Loop Counter

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related