Dear all, I have got a text file containing the following sample data. I would like to convert some of the data into excel file. Basically i just want the field name and the value to be converted into the excel. Can someone help me on how to convert it into excel using excel macro.
Example :
Preferred excel format:Code:START-OF-FILE REFNUMBER=12345 DATEFORMAT=yyyymmdd START-OF-FIELDS FIELD1 FIELD2 FIELD3 FIELD4 . . . FIELD120 END-OF-FIELDS START-OF-DATA VALUEA1| VALUEA2| VALUEA3| VALUEA4|. . . | VALUEA120 VALUEB1| VALUEB2| VALUEB3| VALUEB4|. . . | VALUEB120 . . . VALUE(N)| VALUE(N)2| VALUE(N)3| VALUE(N)4|. . . | VALUE(N)120 END-OF-DATA END-OF-FILE
Code:FIELD1 FIELD2 FIELD3 FIELD4 . . . . FIELD120 VALUEA1 VALUEA2 VALUEA3 VALUEA4 . . . . VALUEA120 VALUEB1 VALUEB2 VALUEB3 VALUEB4 . . . . VALUEB120 . . . VALUE(N) VALUE(N)2 VALUE(N)3 VALUE(N)4. . . VALUE(N)120
Bookmarks