View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Extract lines with regular expressions?

I have over 400+ emails saved in a single text file. Each email
is separated with a dotted line (e.g, one hundred dash "-'
characters).

Rather than manually copying and pasting each email
into a separate file, is there a faster solution? Can I use
regular expressions for this? I'm looking to create a script
that will grab all the emails and save each email into its own
separate file.

I know how to use VBA regular expressions to match text
in a single line... but, I'm not sure how I can match a block
of text located between a pair of dotted lines as described
above. I'd appreciate any tips. Thank you!

Rob