Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regular expressions in VB | Excel Discussion (Misc queries) | |||
Regular Expressions | Excel Programming | |||
Using Regular Expressions with VBA | Excel Programming | |||
Batch extract PDF data to Excel using regular expressions | Excel Programming | |||
VBA and Regular expressions | Excel Programming |