Format numbers

[kadara]

Hi,

I would like to use numbers in 3-digit format: for example 1 to 001, 2 to 002, 10 to 010, 11 to 011 and so on.
In details: I would like to get the following string format W20HYaaa where aaa is a number between 1 and 255.
How could I do that?

 

[Geates]

number = right("000" + aaa, 3)

aaa = 12 : number = 012
aaa = 5 : number = 005
aaa = 245 : number = 245

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[PHV]

yourString = "W20HY" & Right("000" & yourNumber, 3)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kadara]

I test it with the following code:

aaa = 12
number = right("000" + aaa, 3)

MsgBox number

but don't work (the result is 12 instead of 012).

 

[PHV]

Did you try my suggestion ?
Note the & instead of +

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kadara]

Thanks.

The

yourString = "W20HY" & Right("000" & yourNumber, 3)

code works well.

 

[Geates]

Oops, I tend to make syntax errors like that.

& is for strings
+ is for numbers

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[strongm]

>+ is for numbers

Not quite ... + is overloaded. If both operands are strings it will concatenate just like &

 

[PHV]

just like &
Even with Null ?

 

[strongm]

Null is not a string

 

[PHV]

Right.

 

[strongm]

Sorry, I must be missing your point. I quite clearly said "If both operands are strings". If one isn't a string, such as null, then it won't concatenate like & (which isn't overloaded)

 

[PHV]

I meant: Sorry, you're right.

 

[strongm]

Ah!

 

[Geates]

Under what circumstances would you use an overloaded operator? Wouldn't one consider it a poor practice?

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

 

[strongm]

Heck, even if you ignore the ability to concatenate, + is overloaded. It knows how to add integers, longs, singles, and doubles. You may argue that yes, that's what addition is, covers all of those. But VBA's + operator works differently depending on the type of the operands, which is typical of overloading (and concatenation is just an version of that)

Indeed most of the maths operators can be considered overloaded. For example

Msgbox 256 * 256

will error because the operand sees two integer operands and so does an integer calculation, and overflows. Change either operand to a long (e.g. MsgBox 256 * 256&), and the operator does a long calculation instead. This is a classic example of what the object-orientated world sometimes calls ad hoc polymorphism.

Is it bad practice? I'd suggest not.

 

[Geates]

Very good point. Even though I'm aware of such limitations (type overflows), I guess I just take most operators for granted. However, I'm keen to it now

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm