[AccessD] Use Regex - Create Camel Case

Here's a routine to determine if there are invalid characters in a
string using RegEx.  Maybe that will help.

   Private Function HasInvalidChars(ByVal strIn As String) As Boolean
        Dim strInvalid As String = "[""'|\\/*?><~]"
        Try
            Dim rex As System.Text.RegularExpressions.Regex
            ' the double backslash is required to indicate
            ' that the single backslash is a part of the pattern to
search
            rex = New System.Text.RegularExpressions.Regex(strInvalid, _
 
System.Text.RegularExpressions.RegexOptions.IgnorePatternWhitespace)
            If InStr(rex.ToString, strIn) <> 0 Then
                Return True
            End If

        Catch ex As Exception
            UIExceptionHandler.ProcessException(ex)
        End Try

    End Function

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, September 27, 2007 11:34 AM
To: 'Access Developers discussion and problem solving';
dba-sqlserver at databaseadvisors.com; VBA
Subject: [AccessD] Use Regex - Create Camel Case

Folks,

I am looking for a regex expression (preferably with explanation) for
taking an expression and creating a camel case (or PascalCase)
expression.

I get CSV files with headers in them.  All too often the eejits that
created the databases they came from used embedded spaces or other
special use characters (!@#$%^&* etc) in their field names.  I need to
strip these special characters out completely.  I also need to upper
case the valid alpha character that follows any of these special
characters.

John colby becomes JohnColby
%idiotic_Field*name becomes IdioticFieldName

Etc.

It appears that Regex is the key (I am doing this in VB.Net) but until
today I have never really tried to use RegEx and it ain't pretty!

Any help in this would be much appreciated.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com