View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Extract paragraphs from text file (Got it!)

Do you think I will be better off reading each line, one at time,
and append each sentence to a string variable until it encounters
the star * border? That way, only one paragraph at a time is loaded
into an array or string or vData??


Reading/working line-by-line is much slower, normally, than
reading/working in memory. Afew hundred paragraphs is relatively small
amount of data.

You can further split each paragraph into sentences...

Dim vTmp, j&
For n = LBound(vData) To UBound(vData)
vTmp = Split(vData(n), vbCrLf)
Debug.Print "Begin paragraph " & n
For j = LBound(vTmp) To UBound(vTmp)
Debug.Print vTmp(j)
Next 'j
Debug.Print "End paragraph " & n
Next 'n

...and view each sentence in the Immediate Window.

--
Garry

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