You have chosen to sponsor your bid up to a maximum amount of .
I receive a .txt file everyday via email, that I want to convert automatically to a .csv file, while cleaning up some data, and formatting it.
I have attached the .txt file. The .csv format I wish to have is also attached.
The script has to do the following:
1. Extract .txt file from an email account, which the .txt attachment will be sent.
2. Clean up the fields and data into the required columns for .csv
3. rename the .csv file to "Fund Prices DD MMM YYYY", which for this sample is 04 January 2013
4. OUTPUT: return the .csv file as an attachment of an email sent to another designated account.
The code will then sit in my server just to perform this function.