LTrim/RTrim

adamhw · June 14th, 2010, 02:25 PM

Hi there

I have a 16 digit number in my database that I pull out of the database as a recordset - I need to convert it into 4 blocks of 4 on the page - would I use LTrim and RTrim and if so, how would I go about it?

I'm thinking

'first 4 digits

strNo1 = LTrim(recordset("number", 4))

'second 4 digits

strNo2 = LTrim(recordset("number", 4))

'third4 digits

strNo3 = LTrim(recordset("number", 4))

'fourth 4 digits

strNo4 = RTrim(recordset("number", 4))

I know that strNo2 and strNo3 should pull out the first 4 digits but I don't know how to go about pulling out the second 4 and third 4.

Any help much appreciated.

thanks

Adam

classicasp · June 15th, 2010, 10:33 AM

LTrim and RTrim are not the functoins you'd want to use. Try using the "Mid" function instead

Dim MyNumber
MyNumber = "1234567890123456"
Response.Write( Mid(MyNumber , 5, 8) )

ClassicASP.com

Old Pedant · June 15th, 2010, 07:18 PM

Ummm...ClassicASP: That would produce the string "56789012" in the variable MyNumber.

In VBScript, MID's third argument is the *length* of the string, not the ending position as it is in other languages.

*******

If you put the 4 pieces into 4 elements of an array, it's neater code:

Code:

Dim chunks(4)
Dim num 
num = CStr( rs("number") )
For i = 1 To 4
    chunks(i) = Left(num,4)
    num = Mid(num,5)
Next

Then your four strings will be named chunks[1] through chunks[4]