Formatting variables

[JazzLeg]

Hi,

I have date stored in a variable,
its value is '13/09/2002 15:31:47'

I would like to format it to '130902153147'.

Basically removing the '/' and ':' and a few characters.

I would also like to extract the first letter out of a character string, and put in lowercase.

e.g. 'Info' to 'i'

Thanks

 

[onpnt]

you can use the replace function for all of these.
-this is for Tarwn-
Replace(expression, find, replacewith[, start[, count[, compare]]])

so
var = '13/09/2002 15:31:47'
var = Replace(var, "/", "&quot
var = Replace(var, ":", "&quot
or just (for spaces also)
var = Replace(Replace(Replace(var, ":", "&quot, "/", "&quot, " ", "&quot

this is the best I could do with the first character lower casing
javascript would be much easier to due this function unless I'm forgetting
something that I shouldn't be forgetting
str = "Information"
Set RegEx = New RegExp
With RegEx
.Pattern = "I"
.IgnoreCase = True
.Global = True
End With
alert RegEx.Replace(str, "i&quot
Set RegEx = nothing

of course this is not really that good due to all the I's becoming i's then.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[GaryC123]

or more simply put

variable="Info"
startletter=left(variable,1)
wholeword= LCase(startletter) & Mid(variable, 2)
response.write wholeword

 

[onpnt]

told you I was forgetting a really easy function.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[Tarwn]

Yeah, but the function definition was pretty The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea
-computer saying (Wiz Biz - Rick Cook)