Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2009Report 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, 2007Report 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, 2009Report 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: 1853 | Location: New York City | Registered: December 30, 2015Report 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: 115 | Location: Seattle, WA | Registered: April 07, 2015Report 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: 975 | Location: Oklahoma City | Registered: October 27, 2006Report 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: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders