THuG has asked for the wisdom of the Perl Monks concerning the following question:
I have proprietary XML that contains a "formula". An example of this:
*IF *VALUE ManagedSystem.Product *EQ NT *AND *VALUE ManagedSystem.Status *EQ '*OFFLINE'
I want to replace all of the words that begin with an asterisk with some readable text. Also, the AttributeGroup.Attribute names listed in the string should be replaced with their correct display text:
If the value of Product Code is equal to NT and the value of Status is equal to 'OFFLINE'
I can do this with regex, and this isn't too cumbersome with the asterisk words since there aren't that many of them. But the AttributeGroup.Attribute names passes two-thousand. We have scraped them out of the appropriate files and put them into a database, hoping we could use that as a lookup, but I'm not sure how.
It is possible a templating system could help us, but the XML is not something we generate, so we'd have to add template markup, and at that point, we might as well just do the work.
Any ideas for a not-so-hard way to do this?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Search and Replace with a Large Dictionary
by RMGir (Prior) on Oct 08, 2008 at 21:18 UTC | |
|
Re: Search and Replace with a Large Dictionary
by mr_mischief (Monsignor) on Oct 08, 2008 at 22:58 UTC | |
by THuG (Beadle) on Mar 04, 2009 at 20:05 UTC | |
|
Re: Search and Replace with a Large Dictionary
by kyle (Abbot) on Oct 08, 2008 at 21:12 UTC | |
|
Re: Search and Replace with a Large Dictionary
by gone2015 (Deacon) on Oct 08, 2008 at 21:10 UTC |