I'm using format COMT, and when I open the CSV file in Excel, my column gets misinterpretted as a date. To fix it in the spreadsheet, I just prefix with a single quote to show it is alpha.

Problem: When I try to do this from WebFocus, it displays the single quote in a font different than what I'm using in Excel. When I retype the ' in Excel, it turns it to alpha and disappears.

I tried single quote, left quote, double quote, etc.

-* &WFFMT can be either PDF or COMT
-SET &csvQuote = IF &WFFMT EQ 'COMT' THEN '''' ELSE '';
...
IF D_DIFF GE 3 THEN &csvQuote|'3 - 6'
...

Judy

quote:

WebFOCUS 6.4.2

I thought version 6 was never brought to the market.....
the stepped from 5 directly to 7. it must be a typo..

What happens if you save it as EXL2K format.

Judy,

Your gripe is with Microshaft really because, as always, it is second guessing what you want without giving a damn!

If you need it in a true alpha output then could you use an alternative to the minus sign? (perhaps a tilde '~') Then Eggshell won't be able to second guess you - incorrectly

T

If you really must have the '3 - 6' then try this -

      COMPUTE D_DIFF/A6 = '3 '|HEXBYT(150,'A1')|' 6';

T

This worked .. thank you!

COMPUTE D_DIFF/A6 = '3 '|HEXBYT(150,'A1')|' 6';