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

Hi Robert,

Am Thu, 26 Mar 2015 11:57:30 +0100 schrieb Claus Busch:

v= Split(s, Chr(13) & Chr(13) & Chr(10))


or replace chr(13) with nullstring and split at chr(10):

v = Split(Replace(s, Chr(13), ""), Chr(10))


Regards
Claus B.


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.

--
Garry

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