Text file importing & data processing
Hello, I'm new here.
I have text file, which have data blocks, 5-8 rows of data, values in lines are separated as a single space. Between blocks are one blank line feed. Block's length is 5-8 rows, depending of certain varible, which is located fourth row and twentieth value. So it is inside of block.. Text file looks like this:
[1# data block, 5-8 rows]
[2# data block, 5-8 rows]
[3# data block, 5-8 rows]
......
I want to import data blocks to cleartext, like this:
[1# data block, 5-8 rows]
field1=
field2=
field3=
..........
[2# data block, 5-8 rows]
field1=
field2=
field3=
..........
And so on.. Please help me, probably Excel is not the best tool to do this, but I have to use it. Can anyone help step-by-step ? I can extract data values to cleartext, but importing text file to excel as above is difficult..
|