Intelligent XML processing?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
lamdur
Posts: 2
Joined: Wed Mar 16, 2005 1:15 pm

Intelligent XML processing?

Post by lamdur »

This question is in regard to replace filters, but is generalizable for other types of XML-based operations.

Is it possible to process XML data in such a way that all data within the boundaries of tag expressions and processing instructions, e.g., <tag attribute="foo"> is skipped, and only the PCDATA wrapped within tags is matched? The restrict filter seems to be not quite intelligent enough to perform this sort of operation (it may be possible to do this with a regex expression, but I cannot figure out how to write the expression properly).

Example:

Let's say I wanted to find the quote character and replace it with a tilde (but only in PCDATA):

Input:

Code: Select all

<tag1 attribute1="foo" attribute2="bar">Hello<phrase attribute="planet">"World!"<?proc: "foo"?></phrase></tag1>
Output:

Code: Select all

<tag1 attribute1="foo" attribute2="bar">Hello<phrase attribute="planet">~World!~<?proc: "foo"?></phrase></tag1>
Lou Amdur
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Why doesn't the HTML/XML restriction work for this?

Just set it to ignore the tab contents, and only process the data between the tags.
lamdur
Posts: 2
Joined: Wed Mar 16, 2005 1:15 pm

Why?

Post by lamdur »

Because (a) it doesn't seem to like attributes within elements, and (b) doesn't seem capable of properly treating in-line elements. Try it on the samples I posted and let me know how the restrict to XML element filter works out for you.
Lou Amdur
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

To avoid changing the quotes inside the

Code: Select all

<?proc: "foo"?>
you'll have to use a three pass replace.

This filter works nicely:

Code: Select all

Restrict to between tags <tag1>...</tag1>
|  [ ] Include text
|  [ ] Match case
|
+--Restrict to between tags <phrase>...</phrase>
   |  [ ] Include text
   |  [ ] Match case
   |
   |--Perl pattern ["] with [###MARKER###]
   |     [ ] Match case
   |     [ ] Whole words only
   |     [ ] Case sensitive replace
   |     [ ] Prompt on replace
   |     [ ] Skip prompt if identical
   |     [ ] First only
   |     [ ] Extract matches
   |     Maximum text buffer size 4096
   |     [ ] Maximum match (greedy)
   |     [ ] Allow comments
   |     [X] '.' matches newline
   |     [ ] UTF-8 Support
   |   
   |--Perl pattern [<\?proc[^>]*>] with [$0]
   |  |  [ ] Match case
   |  |  [ ] Whole words only
   |  |  [ ] Case sensitive replace
   |  |  [ ] Prompt on replace
   |  |  [ ] Skip prompt if identical
   |  |  [ ] First only
   |  |  [ ] Extract matches
   |  |  Maximum text buffer size 4096
   |  |  [ ] Maximum match (greedy)
   |  |  [ ] Allow comments
   |  |  [X] '.' matches newline
   |  |  [ ] UTF-8 Support
   |  |
   |  +--Perl pattern [###MARKER###] with ["]
   |        [ ] Match case
   |        [ ] Whole words only
   |        [ ] Case sensitive replace
   |        [ ] Prompt on replace
   |        [ ] Skip prompt if identical
   |        [ ] First only
   |        [ ] Extract matches
   |        Maximum text buffer size 4096
   |        [ ] Maximum match (greedy)
   |        [ ] Allow comments
   |        [X] '.' matches newline
   |        [ ] UTF-8 Support
   |      
   +--Perl pattern [###MARKER###] with [~]
         [ ] Match case
         [ ] Whole words only
         [ ] Case sensitive replace
         [ ] Prompt on replace
         [ ] Skip prompt if identical
         [ ] First only
         [ ] Extract matches
         Maximum text buffer size 4096
         [ ] Maximum match (greedy)
         [ ] Allow comments
         [X] '.' matches newline
         [ ] UTF-8 Support
       
Let me know if you want me to email this to you.
Post Reply