I'm looking to produce a mixed-case Excel file name in WebFOCUS. I use this --
ON TABLE PCHOLD AS Weekly_History_of_Docs_and_ICNs FORMAT EXL07 OPEN
I get an excel file opened that is all lower case. A minor thing, but any recommendations?This message has been edited. Last edited by: FP Mod Chuck,
August 10, 2020, 11:21 AM
FP Mod Chuck
John
What operating system is WebFOCUS running under?
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 10, 2020, 12:32 PM
John_Edwards
Windows Server 2015.
August 10, 2020, 01:15 PM
FP Mod Chuck
John
Sorry, it is either all upper case or all lower case on Windows
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 10, 2020, 05:58 PM
Waz
I thought there was a way, but perhaps that was on Linux
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
August 10, 2020, 06:34 PM
John_Edwards
It seems odd, because hold files sent to SQL*Server tables create upper-case names, hold files sent to Excel lower-case. I'm surprised case would come into it in either state, seems to me you pass a string of characters along and the destination slaps them on. Clearly it's more complicated than that.