Folks
I am trying to finish off some documentation for a project I am working on. I have a word document (15000 Lines) that I have to convert into XL so that I can sort data. The date is in the following format in WORD.
DATLAPPSBX01#RMSTDLIST_DATLAPPSBX01
SCRIPTNAME "/opt/tws/TWS/bin/rmstdlist 90"
STREAMLOGON root
DESCRIPTION "Remove stdlist older than 90 days"
TASKTYPE UNIX
RECOVERY STOP
ABENDPROMPT "App Support - Maestro Scheduler"
DATLERSDB01#EC_DROP_PARTITION
SCRIPTNAME "f:\MaestroJobs\PartitionRefresh\DROP_PARTITION_DW_DIM_LEGACY_PRODUCT.bat"
STREAMLOGON UNINET\svc_maestro
DESCRIPTION "EC DROP PARTITION"
TASKTYPE WINDOWS
RECOVERY STOP
ABENDPROMPT "App Support - ERS"
and put them in columns
COL A DATLAPPSBX01#RMSTDLIST_DATLAPPSBX01
COL B SCRIPTNAME "/opt/tws/TWS/bin/rmstdlist 90"
COL C STREAMLOGON root
COL D DESCRIPTION "Remove stdlist older than 90 days"
COL E TASKTYPE UNIX
COL F RECOVERY STOP
COL G ABENDPROMPT "App Support - Maestro Scheduler"
COL A DATLERSDB01#EC_DROP_PARTITION
COL B SCRIPTNAME "f:\MaestroJobs\PartitionRefresh\DROP_PARTITION_DW_DIM_LEGACY_PRODUCT.bat"
COL C STREAMLOGON UNINET\svc_maestro
COL D DESCRIPTION "EC DROP PARTITION"
COL E TASKTYPE WINDOWS
COL F RECOVERY STOP
COL G ABENDPROMPT "App Support - ERS"
Sorry I tried to upload a small sample of the spreadsheet but I could not get it to upload.
Thanks in advance.
Steve
Bookmarks