question Re: How can I remove XML Tag Name attributes in NiFi? in Support Questions

How can I remove XML Tag Name attributes in NiFi?

techNerd — Wed, 16 Jun 2021 06:37:35 GMT

Hi,

is there some way that nifi could remove the attributes inside the XML tag name? Please advise with some example to help me. Appreciate. Thanks

Example:

<name>Nicholas</name>

</particular>

<name>Debbie</name>

<height163</height>

</particular>

to something like:

<name>Nicholas</name>

</particular>

<name>Debbie</name>

</particular>

Re: How can I remove XML Tag Name attributes in NiFi?

MattWho — Wed, 16 Jun 2021 13:26:24 GMT

@techNerd

I am looking at your example and am not clear on what your are "removing"?
looks like you are adding text to your example.

Thanks,

Matt

Re: How can I remove XML Tag Name attributes in NiFi?

techNerd — Thu, 17 Jun 2021 02:09:33 GMT

Hi @MattWho,

Apologies as I made a mistake on the example. The example should be as follow:

Input:

<name>Nicholas</name>

</particular>

<name>Debbie</name>

</particular>

Output:

<name>Nicholas</name>

</particular>

<name>Debbie</name>

</particular>

Are there some ways that NiFi processor could remove the attributes (unit or etc..) inside the XML tag name as mention in the example above? It will be a great help if there is an example with internal processor configuration shown and explanation.

Appreciate your help. Thanks.

Re: How can I remove XML Tag Name attributes in NiFi?

MattWho — Thu, 17 Jun 2021 13:50:41 GMT

@techNerd

Based on yoru example, you can actually modify your XML using the ReplaceText [1] processor.
The processor can be configured with Java regex that would match on the string you want to remove and the replacement value would be set to an empty string.

Your regex pattern in this case would need to match on (don't forget the spaces):

( unit = ".*?")

The parenthesis mark the java regex capture group.
.*? is a non greedy match on any character for zero or more characters until the very next quote. This allows this to match on any variety of unit strings ( meter, kilogram, and lb) from your example

This will result in the following:

<particular> <name>Nicholas</name> <height unit = "meter">183</height> <weight unit = "kilogram" unit = "lb">75</weight> </particular> <particular> <name>Debbie</name> <height unit = "meter">163</height> <weight unit = "kilogram" unit = "lb">45</weight> </particular>

being converted to:

<particular> <name>Nicholas</name> <height>183</height> <weight>75</weight> </particular> <particular> <name>Debbie</name> <height>163</height> <weight>45</weight> </particular>

[1] https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.13.2/org.apache.nifi.processors.standard.ReplaceText/index.html

If you found this addressed your query, please take a moment to login and click "Accept" on this solution.
Thank you,

Matt

Re: How can I remove XML Tag Name attributes in NiFi?

techNerd — Fri, 18 Jun 2021 03:06:14 GMT

Hi @MattWho

Thanks for your help. Appreciate.

Re: How can I remove XML Tag Name attributes in NiFi?

Marc_ — Thu, 29 Jul 2021 13:13:43 GMT

Maybe a TransformXml with this XSLT might be more future proof:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output omit-xml-declaration="yes" indent="yes"/> <xsl:strip-space elements="*"/> <xsl:template match="node()"> <xsl:copy> <xsl:apply-templates /> </xsl:copy> </xsl:template> </xsl:stylesheet>