Similar to the PROPER function in EXCEL

mcinar · March 27th, 2005, 11:45 AM

Hi All,

I have a data in a field with everything in CAPS.
For example: "MAKE RESERVATION"

What I am trying to display is the following;
"Make Reservation". Keep the first initial of each word in CAPS and the rest in LOWER CASE.

Thanks for your help,
:)

MCinar

Love all the creatures because of the creator.

joefawcett · March 28th, 2005, 10:21 AM

Some browsers support the css style

Code:

 text-transform: capitalize

--

Joe (Microsoft MVP - XML)

mcinar · March 28th, 2005, 11:39 AM

Thank you, Joe.

MCinar

Love all the creatures because of the creator.

mcinar · March 28th, 2005, 11:47 AM

Hi Joe,

I tried the following code in IE 6.0, but it didn't work.
<%@ language="vbscript"%>
<% dim strVal
strVal = "THIS IS A TEST"%>

<SPAN STYLE="text-transform: capitalize;"><%=strVal%></SPAN>

Thanks for your help,

MCinar

Love all the creatures because of the creator.

meow · March 28th, 2005, 12:01 PM

AFAIK it works as advertised in IE6. What was the input and how did it turn out? Your variables don't really tell us anything.

If you for instance have a string that's all uppercase you won't see any effect.

(o<
//\ =^..^=

mcinar · March 28th, 2005, 12:32 PM

INPUT --- StrVAL = "THIS IS A TEST"
OUTPUT -- "THIS IS A TEST"

It didn't make it like "This Is A Test"

Thanks,

MCinar

Love all the creatures because of the creator.

joefawcett · March 29th, 2005, 09:03 AM

Capitalize just makes each starting letter a capital, it ignores other letters so you need:

Code:

<% dim strVal
    strVal = "THIS IS A TEST"%>
    strVal = LCase(strVal)
    <SPAN STYLE="text-transform: capitalize;"><%=strVal%></SPAN>

--

Joe (Microsoft MVP - XML)

mcinar · March 29th, 2005, 12:34 PM

It is very helpful.
Thanks, Joe.

MCinar

Love all the creatures because of the creator.