Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to import data from a text file into Excel. The data consists of 1000
records, each record has 13 fields, each field and its corresponding value (separated by a :)is in a row in the text file. A sample of 2 records in text file is as follows: Image Info: Image Name: cslegalvb_1182334115_C1_HDR Date: 1182334115 Full Date: Policy: BR_VM_nt_fs_cs_21_52-4 Save As : (STS_SA_IMAGE) Stream Format: TAR Type: STS_IMG_FULL Server Name: csnans02 LSU Name: /vol/fs_21_dsu7 Size: 4096 Block Size: 8192 Exports: Status: (STS_II_IMAGE_CREATED | STS_II_FILES_CREATED | STS_II_BUSY_READ) Image Group : () Image Info: Image Name: cslegalvb_1182334115_C1_TIR Date: 1182334115 Full Date: Policy: BR_VM_nt_fs_cs_21_52-4 Save As : (STS_SA_IMAGE) Stream Format: TAR Type: STS_IMG_FULL Server Name: csnans02 LSU Name: /vol/fs_21_dsu7 Size: 2531328 Block Size: 8192 Exports: Status: (STS_II_IMAGE_CREATED | STS_II_FILES_CREATED | STS_II_BUSY_READ) Image Group : () How do I import this text file such that each record is contained in a row and value of each field is contained in columns? Thanks in advance for any pointers.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel |