Returns whether this converter can convert the object to the specified type.ĬonvertFrom(ITypeDescriptorContext, CultureInfo, Object)Ĭonverts the given value object to a Boolean object.Ĭonverts the given value to the type of this converter.ĬonvertFromInvariantString(ITypeDescriptorContext, String)Ĭonverts the given string to the type of this converter, using the invariant culture and the specified context.Ĭonverts the given string to the type of this converter, using the invariant culture.ĬonvertFromString(ITypeDescriptorContext, CultureInfo, String)Ĭonverts the given text to an object, using the specified context and culture information.ĬonvertFromString(ITypeDescriptorContext, String)Ĭonverts the given text to an object, using the specified context.Ĭonverts the specified text to an object.ĬonvertTo(ITypeDescriptorContext, CultureInfo, Object, Type)Ĭonverts the given value object to the specified type, using the specified context and culture information.Ĭonverts the given value object to the specified type, using the arguments.ĬonvertToInvariantString(ITypeDescriptorContext, Object)Ĭonverts the specified value to a culture-invariant string representation, using the specified context.Ĭonverts the specified value to a culture-invariant string representation.ĬonvertToString(ITypeDescriptorContext, CultureInfo, Object)Ĭonverts the given value to a string representation, using the specified context and culture information.ĬonvertToString(ITypeDescriptorContext, Object)Ĭonverts the given value to a string representation, using the given context.Ĭonverts the specified value to a string representation. Returns whether this converter can convert the object to the specified type, using the specified context. Returns whether this converter can convert an object of the given type to the type of this converter.ĬanConvertTo(ITypeDescriptorContext, Type) Gets a value indicating whether this converter can convert an object in the given source type to a Boolean object using the specified context. Initializes a new instance of the BooleanConverter class.ĬanConvertFrom(ITypeDescriptorContext, Type) For more information, see the examples in the TypeConverter base class. Instead, call the GetConverter method of the TypeDescriptor class. I have added a Boolean optional “MySql Extended” option which extends the standard 4 digit representation to 5 digits where used with MySql and extended precision is requiredĮxports.You should never create an instance of a BooleanConverter. So here is my custom formatter for an English Language based implementation of Soundex()

In a standard search they will appear different but with reference to their sounded equivalents they all resolve to S530

This could be spelt as Smith, Smyth or Smythe

The standard specified one letter followed by 3 numbers however it should be noted that the MySQL may actually return longer strings. The function takes a word and returns the first letter followed by a number based on the phonetic sound of the word.īasically it strips vowels and W, H,Y, removes double letters then resolves the remainder to number groups I know i can implement this via custom queries as all forms of SQL support soundex but wanted the add to add this functionality to Wapplerįor the few of those who may not know what soundex is, put simply it is a digital representation of a word based on its phonetic sound and was developed for use with names which can often sound alike but by spelt differently. In my early days of using DBase, Clipper, Foxpio, Visual Foxpro i make extensive use of the soundex() function to perform “fuzzy searches” on names. Most of my early systems were Customer Relations Management, Medical Records, Human Resources Systems and Criminal Intelligence Analysis type systems. My background is very much in database management, starting back in the mid 1980s

Foxpro convert string to boolean