Record length ?!?

hcweb · October 31st, 2003, 06:43 PM

Hello all!
I'd like to query a database and upon displaying the record, I'd like to limit the actual visible length of that record.

i.e.:
"John ran around the world to try and catch himself" limited to "John ran around the world..."

Any help would be greatly appreciated.

Imar · October 31st, 2003, 07:12 PM

Hi there,

You can use the Left function to accomplish this:

Code:

Dim MyString
MyString = MyRecordset("AColumn")
Response.Write(Left(MyString, 25) & "...")

will write out the requested value.

If you don't want to break the string in the middle of a word (e.g. worl...), you'll need to do some extra searching in the string. I think the easiest way to do this is to use the Left function to limit the length of the text string. Then you can use InstrRev to find the last space character in the string. Then use the return value of InstrRev in combination with the Left function again, to cut the string at the last space position.

If you need more help with this, post a question here.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

hcweb · November 1st, 2003, 11:16 PM

Thanks Imar! Works like a champ!!