We have a .DBF file in dBaseIII format. We use Quattro Pro [url removed, login to view] but other database programs may open this file as well. Some of the columns have numbers entered as text (ASCII characters preceded by a single quote ' ) with symbols such as ¼, ½, and ¾. We need to convert these columns into decimal values. For example, the text value "'4½" would become a numeric value "4.5". The solution should be a stand-alone windows GUI program that would process a DBF file and convert the columns indicated in a configuration file located in the same directory. The config file will be a list of column names, one column per line, that should be fixed as described above. Here are the names of the columns that should initially be listed in the config file... CALL_1Q_LB, CALL_2Q_LB, CALL_3Q_LB, CALL_ST_LB, COMPLINE_LA1, COMPLINE_LA2, COMPLINE_LA3. Also in same columns you will find the following text. (0) must convert to(0),(ns) must convert to(.00521875),(hd) must convert to(.0104375) (nk) must convert to(.020875),(ds) must convert to(100,000). The interface should simply provide a file open dialog box so that I can select the DB file I would like to process. The resulting file should be in the same folder as the original and have the same name as the original file but with "fixed_" appended to the beginning of the filename. So if I process a file named "[url removed, login to view]" the fixed file will be named "[url removed, login to view]". I may also want to have the option of just replacing the original file with the fixed file (perhaps this could be an option). The program must also remove all of the single quotes (') that precede all characters in all columns. The columns that contain minutes, seconds and tenths of seconds must convert to seconds and tenths of seconds. Example::27.0 converts to 27.0, :31.4 converts to 31.4,:54.6 converts to 54.6, 1:01.8 converts to 61.8 seconds,1:56.8 converts to 116.8 seconds; 2:02.2 converts to 122.2 seconds. Examples are found in columns headed LEAD_TM_1Q, LEAD_TM_2Q, LEAD_TM_3Q and LEAD_TM_FN. Finally in columns CALL_1Q_PK, CALL_2Q_PK and CALL_3Q_PK you will find the following symbols. o…converts to (.167), oo…converts to (.334) these symbols must always convert to the fore-mentioned values when found by the program. We are attaching a sample DBF file that has the problem discussed and the columns mentioned. We have hundreds of files to convert, so the solution must be easy to run and relatively fast.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows 98 second edition and Windows 2000.