XML Parsing

[ljacobs1]

How does one convert XML content or text within an XML element to sub-elements within the parent element? I am trying to use C# which calls a XSL file.

The application is trying to parse the "msg" text in a Syslog server data string to retrieve the src and dest IP addresses as well as the true message.

[Dormilich]

basically copy everything except that what you want to change and insert the elements to change in a separate template.

(maybe) useful threads:
https://bytes.com/showthread.php?t=842976
https://bytes.com/showthread.php?t=841347
regards

[ljacobs1]

I am still not sure how to get xml tags around XML content within a single element. The content I want to tag is multiple strings that are currently with another XML tag. For example; <MsgText>id=xxxxxx srcIP=xxx.xxx.xxx.xxx destIP=xxx.xxx.xxx.xxx msg=xxxxxxx</MsgText>

I want to break out each of those pieces of content into their own tags.

[Dormilich]

then you need some string operations.

see
https://bytes.com/showthread.php?t=829025

regards

[ljacobs1]

There sure is a lot to go through to separate text within a XML file into individual XML tags.

I will have to muddle through it.

I was able to get my XSL file to strip all tags out of the XML. So, I thought I might be able to use Regex within the C# code to separate the individual text components and add XML tags back in.

I just need the pertinent syslog data components to be separated out of the Syslog message so I can store them back in a MySql table.

Thanks.

[Dormilich]

If you're doing the "hard" work (meaning the regex) in C# you can as well transform the whole xml file in C#. on the other hand side if you want to use xslt you should let it do all the work (though I have to admit that xsl is a rather lousy programming language). If I remember right you can use a regex in XSLT 2.0. but until then you have to access each parameter separately.

// taken from the last mentioned thread
// call it from MsgText's parent or change the path on line 12
// this will output the parameter (named in $attrName)
<xsl:template name="getAttr">
    <xsl:param name="attrName"/>
    <xsl:param name="pattern">
        <xsl:value-of select="$attrName"/>
        <xsl:text>=</xsl:text>
    </xsl:param>
// further output code here ...
// extract string from $pattern up to the next space
    <xsl:value-of select="substring-before(substring-after(MsgText, $pattern), ' ')"/>
// ... and here
</xsl:template>

regards