326876 Read/write translation into db

Hi, thanks for looking at our project! This is an interesting one. We have a tab-delineated flatfile text database (not sql) on our server. We need a script which will translate some of the text in this database from English to Spanish. (Note: this is not a request for translation services -- the contents of our file change every day, so we need a solution that's automated). If you know of a Linux server-based solution for this, let me know, but otherwise, I beileve that our best option will be a script that will feed the text into (and out of) Google Translate. Here is an example of what we need translated: [login to view URL] and here is the result when feeding that URL into Google Translate: [login to view URL] (As you can see, Google Translate only translates the first 600 records or so, for some reason.) So -- since there is currently no Google API that will automate translating a file, what we need is a "workaround" script that will do the following: 1.) Make a copy of our database. (let's call this document "[login to view URL]"). 2.) Copy the contents of **column 6 only** of the first 500 records to a temp file. This will look similar to [login to view URL] above (the 500 records at a time is to get around the "600 records" limitation mentioned above). 3.) Feed that URL into Google translate (as above), then capture the output. Write this back to column 6 of the first 500 records of database_es. ULTRA IMPORTANT: Each record's column 6 must be the right one ... the same record as before, translated. In other words, it is essential that the carriage returns separating records must be maintained throughout the process, and that the translation output is is processed so it fits exactly where it belongs on the db. 4.) Continue this process with each set of the 500 records until the file is done (the current source database file is approx. 3700 records, but might grow in the future). This should be something that we can set up and run as a reliable daily cron job. If you have any better ideas for how to do this, please let us know, otherwise, please take a look and we welcome your bids and input. Thanks :)