View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Parse with newline "0D 0D 0A"

Claus,
That might not work as expected if the text file contains groups of
sentences separated by a blank line, and you further want to parse
each sentence without 'breaking' the original structure.


For clarity...

Data recorders output blocks of data (usually at fixed intervals) that
will contain #lines per block. Each 'write' will typically add a
trailing blank line to each block...

[single block structure]
**BEGIN**
Interval...
DataItem
DataItem ID
DataItem Description
DataItem Value

**END**

[multiple block structure]
**BEGIN**
Interval...
DataItem
DataItem ID
DataItem Description
DataItem Value

Interval...
DataItem
DataItem ID
DataItem Description
DataItem Value

**END**

...where the last line in the file will be blank, each block consists of
5 bits of data separated by a trailing blank line.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion