Problem with xml files

[#1]

Hello all,

I have the problem that when I try to work on an XML file, I have things like

<div>, float;# and string;# before the actual data that I want to use.

Can I eliminate them in an easy way?

Purgechar and replace is not working properly...

regards,

Michael

[Anil_Babu_Samineni]

Can you provide more inputs that demonstrate the issue

[#3]

Like this. I just need the figures 😉

[Anil_Babu_Samineni]

I always depends like below

=Replace('float;#0.00000', 'float;#','')

[Kushal_Chawda]

=num(purgechar(lower(trim(FieldName)),'float;#'))

[Kushal_Chawda]

or

keepchar(FieldName,'0123456789')

[Sergey_Shuklin]

Hello, Michael!

Replace will be the short solution:

Replace(TTM,'float;#','')

PFA.

[#8]

sorry, all Solutions don't work...

I've attached the qvw, maybe it helps

[Anil_Babu_Samineni]

Which Field we have to look? Is this related R&D

[#10]

It's TTM for instance