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] Remove quotes around strings?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Remove quotes around strings?
 Login/Join
 
Guru
posted
Is there any way to direct WebFOCUS not to put quotes around strings. (In that way, Excel would treat strings that are numbers as numbers.)

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


Release: WebFOCUS 7.6.8
OS: Windows
Output formats: HTML, PDF, Excel, csv
 
Posts: 256 | Registered: July 21, 2008Reply With QuoteReport This Post
Master
posted Hide Post
When you do a HOLD FORMAT COMT, numbers do not have quotes around them. Now if you have a string that is made up of numbers, for example, an SSN that is defined as an A9 field, then that would have quotes. If you don't want quotes around an alpha field that contains nothing but numbers, then use EDIT or ATODBL to convert the alpha to a number before printing.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 956 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Yes, I thought about holding to COMT, then outputting to Excel from there, but apparently the quotes show up again.

In regard to the ATODBL will that work if there really are some numbers in there sometimes?

Thanks.


Release: WebFOCUS 7.6.8
OS: Windows
Output formats: HTML, PDF, Excel, csv
 
Posts: 256 | Registered: July 21, 2008Reply With QuoteReport This Post
Guru
posted Hide Post
see my answer to your other post which asks the same question


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Remove quotes around strings?

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