Jump to content

.CSV file parse & modify help needed, please.


Guest AlexS
 Share

Recommended Posts

Guest AlexS

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%

,,,,,,,,,,,,,,,,

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...