1 Attachment(s)
Ugly Import Ansi text to Excel
Saw a couple of posts that related, but nothing that answers my unique situation...and its a situation I hope I never have to be in again...Thanks for the help in advance
Using an Ansi report to be imported and final tallies MUST be done using only Excel (licensing and system restrictions). Problem in the file is REAL ugly. It is comprised of several different sections with different widths, not tab or comma delimitated and need some information from at least two different sections. Really need a hand with ideas I can use to capture this data.
Can not manually convert the data due to the tremendous volume of data and the rate the data is collected (daily).
I am sure I am going to have to use sting commands to parse this, but not sure the best way to go about it do to the fluctuating size of the different sections between each other let alone the employee data in them.
The end users are novice Excel users let alone anything else. If I can get this data in, I can formulate it the way they need so it is nice, pretty, and user friendly.
Information needed:
Date From and To
Agent ID (5 digit ID starting in this case with the 57xxx)
Full Name (would be nice but willing to cross reference off of other tabs)
...and all the information under Taken Days
Having additional information such as:
Total Earned
Max Partial Hours
Total Taken
Total Debited
Remaining to Select
Would be ideal, but I am willing to forgo these if necessary.
Unfortunatly the report can not be modified in any way (otherwise I might have an easier time) and no the import can not set to Export to Excel. Nor can additional access be granted to the root data.
Can send the file to whomever request and have included a sample that would be best to copy/paste into notepad before you look at it. The information has been changed to protect the innocent.
If it can't be done I need to know that too... but if all possible I need to try to use VBA and Excel.