NetTalk Central
NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on September 24, 2014, 12:13:00 PM
-
If I export the screen displayed in 1.png I get the attached txt file (rename to .xml). 2.png shows that the Account Number field is is truncated (actually rounded off to the first 15 digits). However viewing the xml file with notepad shows the full, untruncated value for account number.
Is there anything that can be done to display the correct value?
[attachment deleted by admin]
-
Hi terry,
Excel won't display "big" numbers. You will need store the value as Text which can be done by putting <39> before the account number but there may be a more elegant way in the method. You'll need to work out where to do this in the XML file process.
-
Yeah just about what I thought. The account number itself is obviously a string but excel assumes any froup of digits is numeric.
Hopefully Bruce can advise me of where I can do this as part of the export otherwise I'll need to do it via a process export to excel
-
Hi Terry,
There's a specific solution (ie handling numbers > 15 digits) and a generic solution (allowing the programmer to specify the type.)
In your case I'd like you to try the specific solution, and let me know if it works please.
in xFiles.clw
xCell.SetCell method
search for
if not omitted(p_data) and numeric(p_data)
and replace with
if not omitted(p_data) and numeric(p_data) and len(clip(p_data)) < 16
The generic solution is a lot more invasive, and I would need to think before implementing that.
Cheers
Bruce