Unleashing the Full Power of Regular Expressions in Microsoft Office Documents

David Saelman

Rate me:

4.54/5 (12 votes)

16 Jun 2008CPOL6 min read

48.5K

1.1K

Part 1: A method of utilizing Regular Expressions to perform power searches in Microsoft Office Documents using .NET and the Microsoft Office Primary Interop Assemblies

MSOfficeRegExDemo_Src.zip
- MSOfficeRegExDemo_Src
  - MSOfficeRegExDemo.sln
  - MSOfficeRegExDemo
    - AboutBox1.cs
    - AboutBox1.designer.cs
    - AboutBox1.resx
    - bin
      - Debug
        
        Plugins
        
        Sample Docs
        
        ~$Regular Expression Test Document.doc
        
        A Regular Expression Test Document.doc
        
        A Regular Expression Test Document.rtf
        
        Searches.xml
    - ColorCheckedListBox.cs
    - DocumentEngine.cs
    - MainForm.cs
    - MainForm.Designer.cs
    - MainForm.resx
    - MissingPIAForm.cs
    - MissingPIAForm.Designer.cs
    - MissingPIAForm.resx
    - MSOfficeRegExDemo.csproj
    - MSOfficeRegExDemo.csproj.user
    - MSOfficeRegExDemo_VS2005.csproj
    - Program.cs
    - Properties
    - XmlModule.cs
  - MSOfficeRegExDemo_VS2005.sln
  - NumericDateValidator
    - bin
      - Debug
        
        NumericDateValidator.dll
    - NumericalDateValidatorClass.cs
    - NumericDateValidator.csproj
    - NumericDateValidator.csproj.user
    - NumericDateValidator_VS2005.csproj
    - NumericDateValidator_VS2005.csproj.user
    - Properties
      - AssemblyInfo.cs
  - SSN_Validator
    - bin
      - Debug
        
        SSN_Validator.dll
    - Properties
      - AssemblyInfo.cs
    - SSN_Validator.csproj
    - SSN_Validator.csproj.user
    - SSN_Validator_VS2005.csproj
    - SSN_ValidatorClass.cs
msofficeregexdemo_app.zip
- MSOfficeRegExDemo_App
  - MSOfficeRegExDemo.exe
  - Plugins
    - NumericDateValidator.dll
    - SSN_Validator.dll
  - Sample Docs
    - ~$Regular Expression Test Document.doc
    - A Regular Expression Test Document.doc
    - A Regular Expression Test Document.rtf
  - Searches.xml


Microsoft Visual Studio Solution File, Format Version 9.00
# Visual C# Express 2005
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "MSOfficeRegExDemo_VS2005", "MSOfficeRegExDemo\MSOfficeRegExDemo_VS2005.csproj", "{9BA6C2A3-7FAB-41D7-B154-6E4A3FA5435A}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "NumericDateValidator_VS2005", "NumericDateValidator\NumericDateValidator_VS2005.csproj", "{82A934A5-C110-4C41-9E05-0439CF847CAD}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SSN_Validator_VS2005", "SSN_Validator\SSN_Validator_VS2005.csproj", "{E7244FBE-E032-42DF-8640-9DC165E860E2}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{9BA6C2A3-7FAB-41D7-B154-6E4A3FA5435A}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{9BA6C2A3-7FAB-41D7-B154-6E4A3FA5435A}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{9BA6C2A3-7FAB-41D7-B154-6E4A3FA5435A}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{9BA6C2A3-7FAB-41D7-B154-6E4A3FA5435A}.Release|Any CPU.Build.0 = Release|Any CPU
		{82A934A5-C110-4C41-9E05-0439CF847CAD}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{82A934A5-C110-4C41-9E05-0439CF847CAD}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{82A934A5-C110-4C41-9E05-0439CF847CAD}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{82A934A5-C110-4C41-9E05-0439CF847CAD}.Release|Any CPU.Build.0 = Release|Any CPU
		{E7244FBE-E032-42DF-8640-9DC165E860E2}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{E7244FBE-E032-42DF-8640-9DC165E860E2}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{E7244FBE-E032-42DF-8640-9DC165E860E2}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{E7244FBE-E032-42DF-8640-9DC165E860E2}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

David Saelman

Software Developer (Senior) DreamWorks Animation

United States

I started programming a TRS-80 Model I in Junior High School with the goal to write arcade games. Since then, I have had the opportunity to work with a wide variety of technologies and environments ranging from real-time telemetry data systems, state-of-the art animation and rigging software, 3D computer games, non-contact measurement acquisition devices, and digital TV systems. I have worked on everything from low-level device drivers to state of the art GUI apps using C#.

Unleashing the Full Power of Regular Expressions in Microsoft Office Documents

License

Comments and Discussions