p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Text file importing & data processing (http://p2p.wrox.com/showthread.php?t=52764)

jarpola January 16th, 2007 10:27 AM

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..





All times are GMT -4. The time now is 08:59 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.