The coder will create a Microsoft Access database with three methods and a simple test form with three buttons to run them. It must be compatible with Access 2000 to Access 2010. Use simple VBA.
1. Take a table and output a CSV. Column values with commas should be enclosed in double quotes. Double quotes should be replaced with two double quotes.
public sub TableToCsv(tableName as string, filePath as string)
2. Search and replace text in a file. It should handle multiple replacements.
public sub SearchAndReplace(filePath as string, searchText as string, replaceText as string)
3. Parse command line parameters. It should return an array of type Parms below. The command line parameter will have the format command1=value1;command2=value2
Parms as Type
CommandText as string
CommandValue as string
public function ParseParameters() as Parms()
See this post on DbForums about the command line:
[url removed, login to view]