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     [SOLVED] Number to Month
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Number to Month
 Login/Join
 
Member
posted
I have a database where the month is kept in a separate column. The column is populated with numbers 1 to 12

Is there a function in Webfocus that can convert 12 to December?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
 
Posts: 12 | Registered: June 01, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Other then DECODE?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Or a compute/define...something in here may help:

http://forums.informationbuild...061072742#4061072742


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
 
Posts: 146 | Registered: November 09, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
Something like this perhaps.

DEFINE FILE CAR
 MNTH/Mt = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6314 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Or a slight variation......

DEFINE FILE CAR
MNTH/Mtr = SEATS
END

TABLE FILE CAR
SUM MNTH
BY SEATS
END


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can use FPRINT to convert to an ALPHA field ...

DEFINE FILE CAR
MNTH/Mtr = SEATS;
MNTH1/A03 = FPRINT(SEATS,'Mt',MNTH1);
MNTH2/A09 = FPRINT(SEATS,'Mtr',MNTH2);
END

TABLE FILE CAR
SUM MNTH MNTH1 MNTH2
BY SEATS
END


WebFocus 8.201M, Windows, App Studio
 
Posts: 226 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Number to Month

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