• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

LITM field not trimmed in XML output

JMast

Reputable Poster
Hello,

I have a UBE creating XML output for BIP. For some reason, the LITM fields are showing a trailing blank in the XML which interferes with the user doing vlookups in the Excel file. I have rtrim(RV Item,' ') in the UBE. This seems like it should work. I notice that other text fields do not need to be trimmed in the code and do not have the trailing space in the XML.

Thank you for your time,

Jeremy
 

JMast

Reputable Poster
I noticed VR01 does not have the space, so moved my item numbers into RVs based on VR01 and the problem disappears. Must be something in the definition of LITM.
 
Top