LTrim/RTrim

adamhw · #1 (**permalink**) 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 · #2 (**permalink**) 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 · #3 (**permalink**) 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]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chapter 16 Error? - Missing RTrim	wrozyboy	BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9	0	February 18th, 2010 09:12 PM
rtrim, ltrim and len	khronikles	Pro VB Databases	1	June 5th, 2006 03:31 PM
rtrim or substring? Help	bachuss	SQL Server 2000	3	March 1st, 2006 01:05 PM
difference in the codwithout ltrim and right trim	shoakat	Classic ASP Databases	2	October 30th, 2004 01:40 AM