View Single Post
  #3   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

You might want to loop vData to purge the asterisk lines and any empty
line as would normally be found at then end of the file...

'Filter junk lines
For n = LBound(vData) to UBound(vData)
If (vData(n) = "") _
Or (InStr(vData(n), "*") 0) Then
vData(n) = "~": Exit For
Next 'n

'Filter profane words
For Each vWord In Split(sProfaneWords, ",")
For n = LBound(vData) to UBound(vData)
If (InStr(vData(n), vWord) 0) Then
vData(n) = "~": Exit For
Next 'n
Next 'vWord
vData = Filter(vData, "~", False)

--
Garry

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