A Filter Dialog for a DataGridView

'' FILENAME:        TextCleaning.vb
'' NAMESPACE:       PI.Common
'' APPLICATION:     N/A
'' CREATED BY:      Luke Berg
'' CREATED:         8-22-06
'' REVISED BY:      _revisedby_
'' REVISED:         _revised_
'' DESCRIPTION:     A common set of functions for cleaing and escaping input text.


Public Module TextCleaning
    ''' <summary>
    '''   Cleans input text for use in an 'expression' (DataColumn.Expression on msdn) or cleaning
    '''   criteria for a rowfilter of a dataview
    ''' </summary>
    ''' <param name="input">The string to clean</param>
    ''' <returns>A cleaned up version of the input string</returns>
    Public Function CleanCriteriaForFilter(ByVal input As String) As String
        Dim output As String
        output = input.Replace("[", "[[]")
        output = output.Replace("]", "[]]")
        output = output.Replace("[[[]]", "[[]")
        output = output.Replace("*", "[*]")
        output = output.Replace("%", "[%]")
        Return output
    End Function
End Module