(Classic ASP) Scrub Xml

Demonstrates the Scrub method for some common XML cleaning needs.

Note: This example requires Chilkat v9.5.0.77 or greater.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' The Scrub method has options for trimming whitespace from the ends of attributes and content,
' trimming inside whitespace, and for case conversion for tags and attribute names.

' Trimming inside whitespace is defined as replacing CR, LF, and tab chars with SPACE chars, and 
' removing extra SPACE chars so that at most one SPACE separates non-SPACE chars.

' For example, load the following XML:

s = "<xyz><td class="" colHoldingPercent col7"" style=""border-bottom-color: rgb(221, 221, 221);               border-image-outset: 0;  ""> abc" & vbCrLf & "123    456</td></xyz>"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = Server.CreateObject("Chilkat.Xml")
success = xml.LoadXml(s)

Response.Write "<pre>" & Server.HTMLEncode( xml.GetXml()) & "</pre>"

' The XML before scrubbing is:

' <xyz>
'     <td class=" colHoldingPercent col7" style="border-bottom-color: rgb(221, 221, 221);               border-image-outset: 0;  ">abc
' 123    456</td>
' </xyz>

xml.Scrub "AttrTrimEnds,AttrTrimInside,ContentTrimEnds,ContentTrimInside"
Response.Write "<pre>" & Server.HTMLEncode( xml.GetXml()) & "</pre>"

' The XML after scrubbing is:

' <?xml version="1.0" encoding="utf-8"?>
' <xyz>
'     <td class="colHoldingPercent col7" style="border-bottom-color: rgb(221, 221, 221); border-image-outset: 0;">abc 123 456</td>
' </xyz>

%>
</body>
</html>