[dba-VB] Use Regex - Create Camel Case

John,

Or flip the thing around, viz:

Function dbc()
	MsgBox pfGetGoodChars("APN SEQUENCE #$%NUMBER")
End Function

Public Function pfGetGoodChars(str2Parse As String) As String
  Const conGoodChars As String = "abcdefghijklmnopqrstuvwxyz" ' acceptable
characters
  Const conQuote As String = """"
  Dim lng As Long, strTemp As String, bFlipCase As Boolean
  str2Parse = UCase(Left(str2Parse, 1)) & LCase(Mid(str2Parse, 2))
  For lng = 1 To Len(str2Parse)
    If InStr(conGoodChars, Mid(str2Parse, lng, 1)) > 0 Then
      If bFlipCase = True Then
        strTemp = strTemp & UCase(Mid(str2Parse, lng, 1))
        bFlipCase = False
      Else
        strTemp = strTemp & Mid(str2Parse, lng, 1)
      End If
    Else
      bFlipCase = True
    End If
  Next lng
  pfGetGoodChars = strTemp
End Function

Max
 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, September 27, 2007 8:10 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Use Regex - Create Camel Case

I have already downloaded it and am playing around.  Just looking at all the
stuff in Expresso tells me that RegEx can be very complex! 


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Rider
Sent: Thursday, September 27, 2007 3:02 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] Use Regex - Create Camel Case

John,

You may want to take a look a Expresso for creating and testing the regex -
I have found it VERY helpful.  It can be found at
http://www.ultrapico.com/Expresso.htm and cost is minimal (free).

Also check out regular-expressions.info  for a good series of tutorials and
examples.
--
Mark Rider
http://dfwmdug.org

Don't anthropomorphize computers.
They don't like it.
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com