Ummm, there's a function reference online, however...
dim strDate1, strDate2
strDate1 = "11201999"
strDate2 = Left(strDate1, 2) & "-" & Mid(strDate1, 3, 2) & "-" & Mid(strDate1, 5)
-glenn-
Super it worked!
Thanks
Another question??
for a given string "11201999"
Is there a way to say do this on the 2nd character and so on to produce "11-20-1999"?
Thanks!
Brian,
This can be put in a loop and the tags assigned to another array.
<snip>
Dim aAddress
Dim sAddress
sAddress = "650 town center drive,box #2 park center-back dock,costa mesa, ca 92626"
aAddress = Split( sAddress )
sAddress = "<street>" & aAddress(0) & "</street><location>>" & aAddress(1) &_
"</location><city>" & aAddress(2) & "</city><state>" & aAddress(3) &_
"</state> <zip>" & aAddress(4) & "</zip>"
</snip>
--
Nic Roche
Net Extra
www.extra.net.au
=================================================
imagex - Web Imaging - activex thin client
Button Creator, Thumbnail Creator, Imaging Lite, ImageMap Creator,
MouseOver Creator, SlideShow Creator.
Properties, Methods, Events, Software Developers Kit
=================================================
> Is there a way to say when the first comma come up do this, one the second
> comma do this, and on the third comma do this? So that I can turn "650 town
> center drive,box #2 park center-back dock,costa mesa, ca 92626" into
> "<street>650 town center drive</street><location>box #2 park center-back
> dock</location><city>costa mesa</city><state>ca</state> <zip>92626</zip>
>
> Brian
>
>