Service Desk Practitioners Forum
cancel

Removing zero from xml file

SOLVED
Go to solution
Highlighted
Rory Emmans
Outstanding Contributor.

Removing zero from xml file

I am trying to remoce the .o from the ID field of exported service calls with no luck. I have tried to format the excel spreadsheet in text prior to exporting, and editing in XML recieve errors can somebody tell me how to use the INT () command in the ini file to remove the zero prior to the XML generation. I have attached my ini file below
4 REPLIES
Ramaprasad N
Outstanding Contributor.

Re: Removing zero from xml file

I think even if the .0 gets exported to excel, you will not have any problems improting it. Try that and see.
Ramaprasad N
Outstanding Contributor.

Re: Removing zero from xml file

And if you still want to remvoe the .0, you may try this in the excel sheet and then try to export the data.
Select the column which you want to convert and then, data --> text to columns. RUn through the wizard with default options and finally, select 'Text' as the colum data format (in the last step, 3 of 3). Try exporting data again and look for results.

Good luck,

Ram
Gyula Matics_1
Acclaimed Contributor.
Solution

Re: Removing zero from xml file

COLUMNS=INT([servicecall].[number]) AS [NUMBER], ...
Ragu_4
Respected Contributor.

Re: Removing zero from xml file

And also in excel create another row and use =left, Column no.

For Ex:
New row =LEFT(A1,3)
A1 being your ID field
Hope that helps