Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text files to Excel - a difficult one
Hi friends
We have a situation where an elementary planning technique software outputting all its strategic plans in to a word document. I am trying to conver this in to an excel file in order to design a database. The output looks like this( I am giving only thee samples 1.1, 1.2 & 1.3 but the list consisits of 10 -15 plans). 1.1 Staff Training Plan -- Priority: A The Purpose of this plan is: To have an operations team that has the appropriate skills and abilities to perform effectively The Strategy for achieving this will be: 1) Prepare a brief report describing the specific skills and knowledge required to operate the warehouse effectively. Timeframe - by 15.07.04 2) Survey & briefly document the current level of relevent skills each member of our team has Timeframe - by 10.08.04 3) Prepare a schedule of training sessions necessary to fill the skill gap Timeframe - by 30.08.04 The Person or Position Responsible & Accountable for delivering the above is: 1), 2) by DW 3) RD ---------------------------------------------------------- 1.2 Inventory Training Plan -- Priority: C The Purpose of this plan is: To put in place systems to ensure we have the right adequate stock level to meet most demand situations without carrying uneconomical inventory levels. The Strategy for achieving this will be: 1) Prepare the appropriate RFP for a computer system to meet this requirement Timeframe - RFP received by end of October 2) Request a management decision Timeframe - by end of 2004 ----------------------------------------------------------- 1.3 Fast Turnaround Dispatch Plan -- Priority: B RH The Purpose of this plan is: To be in a position to provide delivery within 24 hours for a 90% of orders received The Strategy for achieving this will be: 1) Prepare a brief procedure manual covering each step of the order-filling process Timeframe - by 15.10.04 The Person or Position Responsible & Accountable for delivering the above is: RH ----------------------------------------------------------- I am planning to have excel headers Plan No - 1.2, 1.2 1.3 etc Plan Name: Purpose Strategy Timeframe Priority Person Responsible My problem is that I do not know the code to seperate out text strings what I plan to have headers (plan Name), Priority, purpose etc in to excel columns and list each description under them in each row. Can Somebody please tell me a code for this or point me to an article which will help me to do this. Thanks Sarah W |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text files to Excel - a difficult one
Sarah,
Since most of this has to do with Word, it would probably be a good idea to ask this in the Word NG. But first check if the word document contains any bookmarks (it may if you're lucky = that will greatly simplify it's analysis. That said.. if it comes from a software package.. it may be possible to use a different output or read the data directly from the original app's database rather then parse the Word formatted output. Check with the software vendor to see if thay have some way of reading their data directly, or the format they use to store stuff. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam sarah W wrote : Hi friends We have a situation where an elementary planning technique software outputting all its strategic plans in to a word document. I am trying to conver this in to an excel file in order to design a database. The output looks like this( I am giving only thee samples 1.1, 1.2 & 1.3 but the list consisits of 10 -15 plans). [snap] My problem is that I do not know the code to seperate out text strings what I plan to have headers (plan Name), Priority, purpose etc in to excel columns and list each description under them in each row. Can Somebody please tell me a code for this or point me to an article which will help me to do this. Thanks Sarah W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
Converting Adobe files into Excel files | Excel Discussion (Misc queries) | |||
Difficult to open files in Excel in different countries | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) |