Create a python script that downloads a latest file via sftp, reads the fixed width file and dumps the data to mysql when a condition is meet per row.

I need to create a python script that can run in cron or manually if needed. It needs to read a fixed width text file Example file looks like 011234567891232 023456789012344 010012344567656 025647586958478 014536475638479 Fixed width column widths are for example 2, 4, 4, 5 ie on above data, it would look like this if a space was used to separate columns C1 C2 C3 C4 01 1234 5678 91232 02 3456 7890 12344 01 0012 3445 67656 02 5647 5869 58478 01 4536 4756 38479 Scrips needs to sftp to a server Grab the latest file in the sftp server directory (it would be good if I can specify the number of latest files to grab, ie usually will be 1 latest file, but if for some reason, script does not run for a few days, we should be able to specify on the command line the number of latest files to grab) The script should parse the file and in rows where col 1 (C1) is 01, it should grab C3 and C4 data from the row and add to an existing mysql table The script should ignore rows where C1 is not 01 (eg, if C1 is 02, ignore) If the above example, the script should discover C1 C3 C4 01 5678 91232 01 3445 67656 01 4756 38479 It's pretty simple Questions, let me know Please note, the above example, is only to demostrate. Actual data file has approx 400 chars wide per row, approx 40 cols and typically contains approx 500 rows). We are only interested in a few cols of data. No need to write the cron, or implement, we can do that, we just need the script to work. Steve