Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help extracting data from 3 text files to csv
I have 3 txt files that contain data and i want to generate a single
spreadsheet. 1 Text file contains the data as below: USER = GARYG PU SU CL CR CG 2. Text file contains data as : GEN WINDOW_LIST GARYGWL EXCEPTION = N ,INSTALLATION_DATA = NONE =MA , CAN , MULTI , WA , SDR , ETEL ; 3. Text file contains data as: USERCODE "GARYG" DEFAULT_WINDOW = NONE ,WINDOW_LIST = GARYGWL ; The report i am looking should be like this: USER PRIV WINDOW_LIST APPROVED ACCESS GARYG PU GARYGWL MA SU CAN CL MULTI CR WA CG SDR ETEL How can i do this? Appreciate the help. Thanks JC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help extracting data from 3 text files to csv
It's difficult without seeing the exact appearance of each data file in
relation to the rest. It's obviously not simply placing in adjacent columns but will require some movement of data. It is possible to import more than one text file using the text to columns facility. By importing to the same w/s and manipulating each file you should be able t get it into the required format. It would be best to see your original data in it's raw form to help further. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Jaycee" wrote: I have 3 txt files that contain data and i want to generate a single spreadsheet. 1 Text file contains the data as below: USER = GARYG PU SU CL CR CG 2. Text file contains data as : GEN WINDOW_LIST GARYGWL EXCEPTION = N ,INSTALLATION_DATA = NONE =MA , CAN , MULTI , WA , SDR , ETEL ; 3. Text file contains data as: USERCODE "GARYG" DEFAULT_WINDOW = NONE ,WINDOW_LIST = GARYGWL ; The report i am looking should be like this: USER PRIV WINDOW_LIST APPROVED ACCESS GARYG PU GARYGWL MA SU CAN CL MULTI CR WA CG SDR ETEL How can i do this? Appreciate the help. Thanks JC . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from large text files for beginner | Excel Worksheet Functions | |||
Extracting Numerous Text files into Excel | Excel Programming | |||
Extracting information from more than 1 text files | Excel Programming | |||
Extracting Data from CSV files | Excel Programming | |||
Excel and Text Files - Extracting | Excel Programming |