help extracting data from 3 text files to csv

J

Jaycee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macros to extract data from 3 txt files into a csv 2
Read 3 txt input files and create an XL spreadsheet 0
Get Data from Second Workbook "Please Help" 1
help with macro to read and sort data from multiple text files 3
Extracting data from a text string: 6
Help with data importing from txt file to excel programmatically 2
Read/Write data to/from text files from a spreadsheet. 8
help with macro to read and sort data from multiple text files 0

Top