Remove Office Non-Standard Microsoft Office Tags

jimmyelewis · November 6, 2006

I'm trying to use regular expression to remove some of the non-standard tags from into that is copyed from Microsoft Word to a text area. So far I have:

[code]
$search = array(
'/<city[^>]*>(.*?)<\/city[^>]*>/is',
'/<place[^>]*>(.*?)<\/place[^>]*>/is',
'/mso-[^"]*|mso-[^;]*mso-[^"]*/is',
'/<formulas>(.*?)<\/formulas>/is',
'/o:[^=]*="[^"]*"/is'
);
$replace = array(
'$1',
'$1',
'',
'',
''
);

echo preg_replace($search,$replace,$row['contents']);
[/code]

One of the the values for $row['contents'] is:
[code]
The Semiconductor Power and Electronics Center (SPEC) welcomes Dr. Engelbert Hetzmannseder as he presents an overview of the Eaton Corporation focused on the Eaton Electric Group and an overview of the mission and capabilities of the 
<place w:st="on">
<placename w:st="on">Eaton</placename>
<placename w:st="on">Innovation</placename>
<placetype w:st="on">Center in Milwaukee, Wisconsin</placetype>
</place>
. 

The Speaker
Engelbert Hetzmannseder

Engelbert Hetzmannseder was born in Klaffer,
<place w:st="on">Upper Austria</place>
.  He received his Dipl.-Ing. (B.S., M.S., 1990) and Dr. techn. (Ph.D., 1994) degree in Electrical Engineering from the Technical University of Vienna, Austria.  Since February 1995 he has been with Eaton Corporation /
<placename w:st="on">Innovation</placename>
<placetype w:st="on">Center</placetype>
in
<place w:st="on"><city w:st="on">Milwaukee</city>, <state w:st="on">WI</state>, </place>
, involved with fundamental and applied research on contacts, switching arc phenomena, and arc fault detection for industrial, aerospace, and automotive products.  He holds 8 patents and published 20 papers at international conferences.  
 Since 2000 he has been Technology Manager of the Electrical Architecture & Systems department at the
<place w:st="on">
<placename w:st="on">Eaton</placename>
<placename w:st="on">Innovation</placename>
<placetype w:st="on">Center</placetype>
</place>
.  Capabilities of the EAS group include:
·      Electric Power Management
·      Power electronic, Power quality, and power conversion architectures
·      Diagnostics & prognostics of electrical components and systems
·      Electro-mechanical switching technologies, Arc & plasma science, Contact physics
·      Power systems modeling: magnetic, electric, thermal, electro-mechanical
·      Mechanism synthesis and modeling

  <stroke joinstyle="miter"></stroke>
<formulas>
<f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f>
</formulas>
<path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></path>
<lock v:ext="edit" aspectratio="t"></lock><shape id="_x0000_s1026" style="MARGIN-TOP: 48.4pt; Z-INDEX: 1; MARGIN-LEFT: 401.55pt; WIDTH: 157.1pt; POSITION: absolute; HEIGHT: 213.55pt" type="#_x0000_t75"><imagedata o:title="ENGELBERT 2 005 head" src="file:///C:\DOCUME~1\jakirk\Local%20Settings\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape> <stroke joinstyle="miter"></stroke>
<formulas>
<f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f>
</formulas>
<path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"></path>
<lock v:ext="edit" aspectratio="t"></lock><shape id="_x0000_s1026" style="MARGIN-TOP: 48.4pt; Z-INDEX: 1; MARGIN-LEFT: 401.55pt; WIDTH: 157.1pt; POSITION: absolute; HEIGHT: 213.55pt" type="#_x0000_t75"><imagedata o:title="ENGELBERT 2 005 head" src="file:///C:\DOCUME~1\jakirk\Local%20Settings\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape>


 


[/code]

Whats returned from the preg_replace:
[code]
The Semiconductor Power and Electronics Center (SPEC) welcomes Dr. Engelbert Hetzmannseder as he presents an overview of the Eaton Corporation focused on the Eaton Electric Group and an overview of the mission and capabilities of the 

<placename w:st="on">Eaton
Innovation
Center in Milwaukee, Wisconsin
</place>
. 


The Speaker
Engelbert Hetzmannseder

Engelbert Hetzmannseder was born in Klaffer,
Upper Austria
.  He received his Dipl.-Ing. (B.S., M.S., 1990) and Dr. techn. (Ph.D., 1994) degree in Electrical Engineering from the Technical University of Vienna, Austria.  Since February 1995 he has been with Eaton Corporation /
Innovation
Center
in
Milwaukee, <state w:st="on">WI</state>,
, involved with fundamental and applied research on contacts, switching arc phenomena, and arc fault detection for industrial, aerospace, and automotive products.  He holds 8 patents and published 20 papers at international conferences.  

 Since 2000 he has been Technology Manager of the Electrical Architecture & Systems department at the

<placename w:st="on">Eaton
Innovation
Center
</place>
.  Capabilities of the EAS group include:
·      Electric Power Management
·      Power electronic, Power quality, and power conversion architectures
·      Diagnostics & prognostics of electrical components and systems

·      Electro-mechanical switching technologies, Arc & plasma science, Contact physics
·      Power systems modeling: magnetic, electric, thermal, electro-mechanical
·      Mechanism synthesis and modeling

  <stroke joinstyle="miter"></stroke>

<path gradientshapeok="t" ></path>
<lock v:ext="edit" aspectratio="t"></lock><shape id="_x0000_s1026" style="MARGIN-TOP: 48.4pt; Z-INDEX: 1; MARGIN-LEFT: 401.55pt; WIDTH: 157.1pt; POSITION: absolute; HEIGHT: 213.55pt" type="#_x0000_t75"><imagedata src="file:///C:\DOCUME~1\jakirk\Local%20Settings\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape> <stroke joinstyle="miter"></stroke>

<path gradientshapeok="t" ></path>
<lock v:ext="edit" aspectratio="t"></lock><shape id="_x0000_s1026" style="MARGIN-TOP: 48.4pt; Z-INDEX: 1; MARGIN-LEFT: 401.55pt; WIDTH: 157.1pt; POSITION: absolute; HEIGHT: 213.55pt" type="#_x0000_t75"><imagedata src="file:///C:\DOCUME~1\jakirk\Local%20Settings\Temp\msohtml1\01\clip_image001.jpg"></imagedata></shape>


 


[/code]

Things like:
[code]
<placename w:st="on">Eaton
Innovation
Center in Milwaukee, Wisconsin
</place>

<placename w:st="on">Eaton
Innovation
Center
</place>
[/code]

remain while the others are replaced. I think that it might have something with those tags been embed in other tags, I've tried different things but I'm not sure what to do.

rea|and · November 8, 2006

Yes, regex engine usually doesn't work with nested patterns. But in this case I guess you could define one more pattern that matches <place*:
first replace those tags starting with <place (something like '/<place[b]\B[/b][^>]*>(.*?)<\/place[b]\B[/b][^>]*>/is' ) and then replace the last ones (that match <place).

Sign In

Remove Office Non-Standard Microsoft Office Tags

Recommended Posts

jimmyelewis

Link to comment

Share on other sites

rea|and

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information