H
henry
I have 800 job data, each has about 8-10 different sub-
data components. I originally copied the file from a raw
Unix file to Excell 2000 spreadsheet, & it comes up all
in 1 single column. Now, I need to split all the data
into different columns, in a such a way that the sub-data
in each main job data will not be mixed up and will still
properly correspond from the respective main job data.
I tried using DATA sort, then TEXT TO COLUMN (all
possible options) so far, but the sub-data are always
getting sorted too, thus, getting mixed up and not going
accroding to the way the job data are sorted.
Here's a sample of each component (800 in total):
/* ---------- VSUC_UTL_DATEJOB ------------ */
insert_job: VSUC_UTL_DATEJOB job_type: c
command: date
machine: p1
owner: p1@p2
permission:
date_conditions: 1
days_of_week: all
start_times: "19:00"
description: "Daily test job"
n_retrys: 3
std_out_file: /autosys/std_out/$AUTO_JOB_NAME.out
std_err_file: /autosys/std_err/$AUTO_JOB_NAME.err
alarm_if_fail: 1
Please help.
data components. I originally copied the file from a raw
Unix file to Excell 2000 spreadsheet, & it comes up all
in 1 single column. Now, I need to split all the data
into different columns, in a such a way that the sub-data
in each main job data will not be mixed up and will still
properly correspond from the respective main job data.
I tried using DATA sort, then TEXT TO COLUMN (all
possible options) so far, but the sub-data are always
getting sorted too, thus, getting mixed up and not going
accroding to the way the job data are sorted.
Here's a sample of each component (800 in total):
/* ---------- VSUC_UTL_DATEJOB ------------ */
insert_job: VSUC_UTL_DATEJOB job_type: c
command: date
machine: p1
owner: p1@p2
permission:
date_conditions: 1
days_of_week: all
start_times: "19:00"
description: "Daily test job"
n_retrys: 3
std_out_file: /autosys/std_out/$AUTO_JOB_NAME.out
std_err_file: /autosys/std_err/$AUTO_JOB_NAME.err
alarm_if_fail: 1
Please help.