ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   help extracting data from 3 text files to csv (https://www.excelbanter.com/excel-programming/440200-help-extracting-data-3-text-files-csv.html)

Jaycee[_2_]

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

Russell Dawson[_2_]

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
.



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com