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,

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

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. :-(

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,

take a look at this post

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

add a macro to remove the extra column

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.

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.