import sys
from dbfpy import dbf

def main(source, target):
    olddb = dbf.Dbf(source)
    newdb = dbf.Dbf(target, new=True)
    fields = [field for field in olddb.fieldDefs if field.typeCode != 'F']
    newdb.addField(*fields)
    fieldnames = [field.name for field in fields]
    for oldrec in olddb:
        newrec = newdb.newRecord()
        for name in fieldnames:
            newrec[name] = oldrec[name]
        newrec.store()
    olddb.close()
    newdb.close()

if __name__ == '__main__':
    if len(sys.argv) != 3:
        print 'Usage: filter.py source target'
        sys.exit()
    source, target = sys.argv[1:]
    main(source, target)