Formatting a numeric for an XML

AitorEG · 2017-10-24

Hi everyone,

I am creating an XML file for deploy it into an external application. In the NAV record, I have a decimal value (Gross Weight (Kg), that I must write it on a node in that XML file.
I am using this for adding to the node:


lvl5XMlNode := XMLDocOut.createNode(1,'TOTALWEIGHT','');
lvl4XMlNode.appendChild(lvl5XMlNode);
PackingHeader.CALCFIELDS("Gross Weight (Kg)");
DomTextNode := XMLDocOut.createTextNode(FORMAT(PackingHeader."Gross Weight (Kg)"));
lvl5XMlNode.appendChild(DomTextNode);

I am formating to a text tyope, because the node as to be a text, but when processing the XML file in the external application, I see this error:

TOTALWEIGHT specified must be numeric

How can I use the format expression to generate a numeric node?

Thank you very much!

NavNab · 2017-10-24

Hello @AitorEG

All you need is:

FORMAT(MyValue, 0, '<Standard Format,9>');

AitorEG · 2017-10-24

Solved using:

lvl5XMlNode := XMLDocOut.createNode(1,'TOTALWEIGHT','');
lvl4XMlNode.appendChild(lvl5XMlNode);
PackingHeader.CALCFIELDS("Gross Weight (Kg)");
[b]Num2String :=FORMAT(PackingHeader."Gross Weight (Kg)");
Num2String := SELECTSTR(1,Num2String) + '.' + SELECTSTR(2,Num2String);[/b]
DomTextNode := XMLDocOut.createTextNode(Num2String);
lvl5XMlNode.appendChild(DomTextNode);

Yury · 2017-10-24

Be careful, it depends on your regional settings delimiter

AitorEG · 2017-10-24

Yury wrote: »

Be careful, it depends on your regional settings delimiter

Thank you, I'll take care of it.

NavNab · 2017-10-24

Hello @AitorEG

All you need is:

FORMAT(MyValue, 0, '<Standard Format,9>');

AitorEG · 2017-10-24

NavNab wrote: »
Hello @AitorEG

All you need is:
FORMAT(MyValue, 0, '<Standard Format,9>');

Thanks, It worked perfectly, and it's simpler than my solution.
Really thanks!

NavNab · 2017-10-24

You're welcome. I'm glad it helps

Juhl · 2017-10-24

You can even write it like 0,9)

Formatting a numeric for an XML

Best Answer

Answers

Categories