Search and Replace in Multiple Excel Files with IceTeaReplacer

I believe that OpenRules users will find that a new free tool called “IceTeaReplacer” can be very useful for doing search&replace in OpenRules repositories. Here is a functional description from their website:

IceTeaReplacer is a simple, yet a powerful tool to search inside multiple Microsoft’s Office Word (doc, docx), Excel (xls, xlsx) files within a directory (and it’s subdirectories) and replace provided phrase. Options available:

  • Perform search before replacing
  • Match whole word only
  • Ignore word case
  • Do backup before replace
  • Deselect files on which you don’t want to perform replace.

Here is an example of its graphical interface:

It would be nice if the product would also:

  • show names of worksheets, numbers of found occurrences and optionally their coordinates (row:col)
  • open a worksheet with the found word and allow navigation through multiple occurrences
  • not to force to close Excel before “Search”.

Anyway, we want to thank the author of this simple but very useful tool.

This is another proof how useful to stick to the standard formats like “xls” instead of inventing proprietary ones: third parties automatically add useful functionality to your product. OpenRules users already enjoy the power of Google Docs while doing collaborative rules management.

Advertisements

About jacobfeldman

CTO at www.openrules.com http://www.linkedin.com/in/jacobfeldmanopenrules
This entry was posted in OpenRules Specific, Tools and Technologies. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s