Silver ⭐️⭐️⭐️

Solved

How can I remove XML Tag Name attributes in NiFi?

5 replies
7748 views
Translate All

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>

Apache NiFi

MattWhoAnswer

Titanium ⭐️⭐️⭐️

@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

MattWho

Titanium ⭐️⭐️⭐️

@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

Translate

techNerdAuthor

Silver ⭐️⭐️⭐️

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.

Translate

MattWhoAnswer

Titanium ⭐️⭐️⭐️

@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

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.