tags:

views:

50

answers:

3

I have a large XML, looking like this:

<gender>M</gender>
<last-name>*</last-name>
<profession>2165dda2-dc59-41af-acb5-06d8914c4841</profession>
<first-name>*</first-name>
<mail-confirmation>1</mail-confirmation>
<fax-confirmation>1</fax-confirmation>

I only want to keep the tags. I found a way to search IN the tag, like this:

<profession[^>]*>([^<]*?)</profession>

but how do I search everything outside of it? I tried to just flip it, like:

</profession[^>]*>([^<]*?)<profession>

or

</profession>([^<]*?)<profession[^>]*>

but that won't work.

A: 

What about

# Perl
$xml =~ s/^<profession>.*<\/profession>$/<profession><\/profession>/m;

Just make sure to use the multiline modifier.

Frank Straetz
I'm not really using perl. I'm stuck with notepad++'s regex capabilities. Or sed.
skerit
@skerit You do not have a programming question then, do you?
Sinan Ünür
I have a question about a certain regular expression, it's the same thing as asking something about a specific SQL query.
skerit
Oops, I just realized you want the data OUTSIDE the profession tags gone. Well, Sinan Ünür's example is really good but Perl. Actually it's quite easy, like $xml =~ /<profession>(.*?)<\/profession>/sg but I'm not sure about the regex capabilities of Notepad++. Sorry for the misunderstanding.
Frank Straetz
+1  A: 

Don't use regular expressions to parse XML. Use an XML parser:

#!/usr/bin/perl

use strict; use warnings;

use XML::LibXML::Reader;

my $reader = XML::LibXML::Reader->new(IO => \*DATA)
    or die "Cannot read from \\*DATA\n";

while ( $reader->read ) {
    print $reader->readInnerXml if $reader->localName eq 'profession';
}

$reader->finish;
print $reader->document->toString(1);

__DATA__
<person>
<gender>M</gender>
<last-name>*</last-name>
<profession>2165dda2-dc59-41af-acb5-06d8914c4841</profession>
<first-name>*</first-name>
<mail-confirmation>1</mail-confirmation>
<fax-confirmation>1</fax-confirmation>
</person>

Output:

C:\Temp> t
2165dda2-dc59-41af-acb5-06d8914c4841

See XML::LibXML::Reader.

Sinan Ünür
+1  A: 

Strictly you can't parse XML with a regex.

Quick and dirty solution with sed is to grep the lines with profession then replace "profession" and "/profession" with "" (markup is stripping the < > )

A quick and simple grep, that I didn't think of that!
skerit
You have to be careful if line endings can appear inside the tag