View Single Post
  #1 (permalink)  
Old January 16th, 2007, 10:27 AM
jarpola jarpola is offline
Registered User
 
Join Date: Jan 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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..



Reply With Quote