Vb functions
From Dedupe
Revision as of 00:03, 3 June 2010; view current revision
←Older revision | Newer revision→
←Older revision | Newer revision→
I've just copied/pasted the headers from the visual basic functions which have been drafted to date. This page can be used to give a few lines about what each function is for, how to use it any potential discussion about improvements, bugs etc?
Possibly also requests could go in here?
Contents |
[edit]
Caverphone
' Author: ltickett@gmail.com ' Version: 0.2 ' Feel free to edit/copy/distribute/sell etc ' This function generates a caverphone key for inWord
[edit]
Country
' Author: ltickett@gmail.com ' Feel free to edit/copy/distribute/sell etc ' This function is far from finished + requires internal.mdb to work ' The function hopefully will support the most common file formats (csv, xls, mdb, dbf...) ' reading them into internal.mdb, scanning the specified fields for country names (or iso codes?) ' and adding a column... this will be needed to make matching countries successful and to allow ' reports to accurately determine country distribution from input files? ' Hopefully the function can be adapted to locateTown or any other key field to which we ' have a relatively fixed, finite set of data to search for? Needs serious discussion!!
[edit]
Levenshtein
' Author: ltickett@gmail.com ' Version: 0.1 ' Feel free to edit/copy/distribute/sell etc ' 2006-05-20, Baard, Added declare of cost and explicit type definition on integer variables. ' 2006-05-20, Baard, Corrected cost formula to include equality cost. ' 2006-05-21, Baard, Removed redundant declaration introduced 2006-05-20 by myself.
[edit]
Ngram
' Author: ltickett@gmail.com ' Version: 0.2 ' Feel free to edit/copy/distribute/sell etc
[edit]
Replace
' Author: ltickett@gmail.com ' Version: 0.2 (changed to vbBinaryCompare because cASe DoES maTTEr :) ' Feel free to edit/copy/distribute/sell etc ' This function needs to be used in Visual Basic 5 ' Visual Basic 6 has already implemented Replace()
[edit]
Replace Recur
' Author: ltickett@gmail.com ' Version: 0.2 ' Feel free to edit/copy/distribute/sell etc ' This function needs to be used in Visual Basic 5 ' because we don't have regular expressions! ' Surely there must be an easier way?
[edit]
Soundex
' Author: ltickett@gmail.com ' Version: 0.3 ' Feel free to edit/copy/distribute/sell etc ' This function generates 4 character soundex key for inWord
[edit]
Tidy Number
' Author: ltickett@gmail.com
' Version: 0.1 (23/05/06)
' Feel free to edit/copy/distribute/sell etc
' The function is used to convert a "dirty" phone or
' fax number into a purely numerical number which is dialable
' from the UK. (UK numbers begin 0... and others 00... )
' The function could be adapted to return all numbers as
' dialable from a different country.
' Input: idCode is the international dialing code (optional)
' Example:
' tidyNumber("+44(0)1702 123456","44") returns "01702123456"
' tidyNumber("786(123)456","1") returns "001786123456"
' Note: It is important we don't pass NULL or 0 length strings
' to this function. If we wanted we could add a check to cope
' with these values.
