Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a text file created and wish to create a MS-Excel spreadsheet
w/columns the 1st column should be static while the row could have variable data to append. Any ideas/scripts to share will be appreciated. Sample File: Client: PSHBGMCGAPP01 Backup ID: PSHBGMCGAPP01_1101705374 Policy: McGregorServersDailyBackup Policy Type: MS-Windows-NT Sched Label: MonthlyFull Schedule Type: Full Backup Retention Level: 6 months (6) Backup Time: 11/29/2004 00:16:14 Elapsed Time: 000:36:58 Expiration Time: 06/03/2005 01:16:14 Compressed: no Encrypted: no Kilobytes: 11845986 Number of Files: 26292 Primary Copy: 1 Image Type: 0 (Regular) Keyword: (none specified) Ext Security Info: no File Restore Raw: no Image Dump Level: 0 File System Only: no Object Descriptor: (none specified) Multiplexed: no TIR Available: no Backup Copy: Standard (0) Client: PSHBGMCGAPP01 Backup ID: PSHBGMCGAPP01_1101531734 Policy: McGregorServersDailyBackup Policy Type: MS-Windows-NT Sched Label: DailyIncremental Schedule Type: Differential Incremental Backup Retention Level: 6 weeks (2) Backup Time: 11/27/2004 00:02:14 Elapsed Time: 000:11:15 Expiration Time: 01/08/2005 00:02:14 Compressed: no Encrypted: no Kilobytes: 369501 Number of Files: 2202 Primary Copy: 1 Image Type: 0 (Regular) Keyword: (none specified) Ext Security Info: no File Restore Raw: no Image Dump Level: 0 File System Only: no Object Descriptor: (none specified) Multiplexed: no TIR Available: no Backup Copy: Standard (0) Required output: ================================================== ============================== Col 1 Col 2 Client: PSHBGMCGAPP01 PSHBGMCGAPP088 Backup ID: PSHBGMCGAPP01_1101705374 PHSNSNNNS01_1919 Policy: McGregorServersDailyBackup XXXX Policy Type: MS-Windows-NT XXXX Sched Label: MonthlyFull XXXX Schedule Type: Full Backup XXXX Retention Level: 6 months (6) Backup Time: 11/29/2004 00:16:14 Elapsed Time: 000:36:58 Expiration Time: 06/03/2005 01:16:14 Compressed: no Encrypted: no Kilobytes: 11845986 Number of Files: 26292 Primary Copy: 1 Image Type: 0 (Regular) Keyword: (none specified) Ext Security Info: no File Restore Raw: no Image Dump Level: 0 File System Only: no Object Descriptor: (none specified) Multiplexed: no TIR Available: no Backup Copy: Standard (0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Getting a file and Saving a File | Excel Discussion (Misc queries) | |||
convert number into corrseponding text | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
import csv file | Excel Discussion (Misc queries) |