Guest AlexS Posted May 25, 2005 Posted May 25, 2005 AutoIT geeks! Please help out with an AutoIT script. Below is a small excerpt from a .CSV file that needs massaged the following way: 1. Delete all blank lines 2. Convert proprietary date format to lay person legible format (field 1 and field 15 below on every line), shown like this, e.g.: 050304 is actually 2005, March 04, to be converted to this: 03/04/2005. thanks much! 050304,222,2,51.27,0,0,0,51.27,46.16,11.07%,0,0,0,48.74,050422,4.93% 050304,333,2,23.24,0,0,0,23.24,20.5,13.37%,0,0,0,21.2,050414,8.78% ,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,, 050317,121,1,35.5,0,0,0,35.5,38.5,8.45%,0,0,0,36.3,050401,2.25% ,,,,,,,,,,,,,,,,
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now