Help with letters

ittorget · October 13th, 2003, 12:27 PM

I need to know how to do this.....
If i have a tabell in a database with a cell containing a name with 14 letter.

Example: kalle andersson

If i want this name to be shoen as this instead: kalle anders...

How is this posible with script.
I know i must count the letters in the questin but how ??

Greg Griffiths · October 13th, 2003, 06:53 PM

You can use the LEFT and RIGHT commands at the ASP level to get this effect, also the SUBSTRING command in Javascript on the client side will do the same thing.

balakumar1000 · October 13th, 2003, 11:53 PM

You can use the select statement like this:

select case
when len(firstname) > 5 then substring(firstname,1,3) + '...'
else firstname
end
from table1

--substring(expr, starting, length)

Balakumar V.

jacob · October 14th, 2003, 01:11 PM

I once did something like this when I had to truncate breadcrumbs...

Code:

full = recTmp("thename")
name = Trim(Left(full, numberOfcharacters))
If Len(full) > numberOfcharacters Then 
   name = name & "..."
End If

Then you can use 'name' to display.

Hope it helps

Jacob.