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] Excel Formula question
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Excel Formula question
 Login/Join
 
Guru
posted
Since I have a field that sometimes produces real strings and sometimes produces numeric values, WebFOCUS produces the column to Excel as strings with quotes around them so even when they are numeric values, Excel can't treat them as strings.

I'm wondering if I can trick Excel and try to put a formula into the field so if the field was equal to 100, I would put in '=100' as the value. However, when I do that, I just get an '=100' displayed in the cell. Is there any way to do this?

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
Expert
posted Hide Post
Hi Channy,

Here are some documents on the techsupport website that may be of help:

Changing double quotes to single quotes
Tranforming an Excel into a flat file
Suppress quotes around alpha data when held to .csv filetype

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks... Unfortunately it is telling me it always puts quotes (it doesn't check to see if there is a space or other reason to put them - it just does it). Which means I am out of luck. :-(


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
quote:
Originally posted by ChannyS:
Since I have a field that sometimes produces real strings and sometimes produces numeric values, WebFOCUS produces the column to Excel as strings with quotes around them so even when they are numeric values, Excel can't treat them as strings.


they may be numeric values but they are in alpha format, you will probably need to use Macros/VBA in conjunction with a template to get round this...

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


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
<JG>
posted
take a look at this post

http://forums.informationbuild...741093113#7741093113

add a macro to remove the extra column
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Couldn't you create an extra column of numeric format that contains the 'translated' value of the original column (by using FTOA or just good old plain EDIT)? If the original field has non-numerics in it, the 'translation' will produce 0 as a result.


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
JG - in regard to macros - back to the Excel 2007 problem....

GamP - sometimes I really do want alpha values (like NA for example) so zero's won't do.


Release: WebFOCUS 7.6.8
OS: Windows
Output formats: HTML, PDF, Excel, csv
 
Posts: 256 | Registered: July 21, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Excel Formula question

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