LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regular expressions in VB FiluDlidu Excel Discussion (Misc queries) 4 March 21st 08 01:10 AM
Regular Expressions sl Excel Programming 2 January 22nd 07 11:27 PM
Using Regular Expressions with VBA Andrew Hall NZ Excel Programming 5 November 21st 06 09:30 PM
Batch extract PDF data to Excel using regular expressions [email protected] Excel Programming 0 July 25th 06 10:12 AM
VBA and Regular expressions Friedrich Muecke Excel Programming 3 October 3rd 03 01:46 AM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"