Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXL2K vs XLSX - Special characters
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] EXL2K vs XLSX - Special characters
 Login/Join
 
Master
posted
Hello

I have a text file with 2 fields in it. One field is A10 and other is A100. We used to have EXL2K format in WF7 and data used to show up fine. Now in WF8, we changed to "ON TABLE PCHOLD FORMAT XLSX" and A100 field is showing up with special characters at the beginning and ending of the actual data in that field. It shows 2 boxes. No issues with HTML/PDF/EXL2K output format. Issue only with EXL07/XLSX.

I tried TRIM etc but not able to get rid of those. Please suggest any debug options.

Thank you.

This message has been edited. Last edited by: Enigma006,


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Take a look at this thread:

Allowing special characters to display report in Excel 07


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Master
posted Hide Post
quote:
Originally posted by Dan Satchell:
Take a look at this thread:

Allowing special characters to display report in Excel 07


Dan, my data doesn't have any special characters but they are showing up in Excel 2007. In EXL2k, data is clean.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Do you see special characters when you run this?
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE PCHOLD FORMAT XLSX
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1660 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Are they varchars - AxxV?


WebFOCUS 8.2.03 - Production
WebFOCUS 8.2.04 - Sand Box
Windows 2012 R2 Server
HTML, PDF, Excel
In FOCUS since 1980
 
Posts: 116 | Location: Seattle, WA | Registered: April 07, 2015Reply With QuoteReport This Post
Master
posted Hide Post
"Are they varchars - AxxV?"

That is what I was thinking. If so, the special characters are the binary length of the data.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 919 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
It would be interesting to know what the byte-values of those characters are.

You can unzip the xlsx file into a directory with xml files. This particular data is in one of them, that may take some digging. The byte-value can be seen using a hex-editor or similar tool.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1643 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] EXL2K vs XLSX - Special characters

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.