Skip to main content
Solved

Hi All, I have encounered a strange behavior with XML Flattener. It skips some values in XML.

  • April 14, 2022
  • 4 replies
  • 28 views

nurbek
Contributor
Forum|alt.badge.img+3

I have flatten xml file, and some data are missed. For example <p>Свободная ёмкость — <b>627 млн.м<sup>3</sup></b>

        <span class="up">11</span></p> it should be 627 млн.м, but it skipped and only values 3 and 11 are in place. In xml ex1 i have highlighted items which are missed in xml example.png. Also attached workbench.

Best answer by debbiatsafe

Hi @nurbek​ 

The behaviour you're seeing is occuring because of the way the ³ symbol (cubed/superscript 3) is represented in your file as <sup>3</sup>.

Use the StringReplacer to replace any instances of <sup>3</sup> with the equivalent HTML character &#179; and the XMLFlattener should output the expected attributes.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • 2077 replies
  • April 19, 2022

Hi @nurbek​ 

Please, send us the file. It's not in the transformer FeatureReader.

 

 

Thanks in Advance,

 

Danilo


nurbek
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • 11 replies
  • April 20, 2022

Hi @nurbek​ 

Please, send us the file. It's not in the transformer FeatureReader.

 

 

Thanks in Advance,

 

Danilo

Hi @danilo_fme​ ,

please find file in attached


debbiatsafe
Safer
Forum|alt.badge.img+21
  • Safer
  • 648 replies
  • Best Answer
  • April 20, 2022

Hi @nurbek​ 

The behaviour you're seeing is occuring because of the way the ³ symbol (cubed/superscript 3) is represented in your file as <sup>3</sup>.

Use the StringReplacer to replace any instances of <sup>3</sup> with the equivalent HTML character &#179; and the XMLFlattener should output the expected attributes.


nurbek
Contributor
Forum|alt.badge.img+3
  • Author
  • Contributor
  • 11 replies
  • April 21, 2022

Hi @nurbek​ 

The behaviour you're seeing is occuring because of the way the ³ symbol (cubed/superscript 3) is represented in your file as <sup>3</sup>.

Use the StringReplacer to replace any instances of <sup>3</sup> with the equivalent HTML character &#179; and the XMLFlattener should output the expected attributes.

@debbiatsafe​ thanks a lot, it seems to work