As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
Connect to myibi
posted September 24, 2007 02:56 PM
Is there a Function in WebFOCUs to convert the String to InitCap. Eg: "CAR" to "Car" and "COUNTRY" to "Country" Regards, MSAM
posted September 24, 2007 02:59 PM
there is in most databases, or you can create a function on your database to do it.
I'm not sure about webfocus, it's just another option.
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
posted September 24, 2007 03:12 PM
There is a function that converts words, I'm home so don't have the exact name, believe it is LCWORD
Posts: | Location: 1317 Council Bluffs, IA | Registered: May 24, 2004
posted September 24, 2007 03:13 PM
Thanks for the Info Jason !!!
posted September 24, 2007 03:14 PM
I think you wnat to use the function lcword like this.
DEFINE FILE CAR
TABLEF FILE CAR
PRINT COUNTRY KOUNTRY
W GERMANY W Germany
FOCUS 7.6 MVS PDF,HTML,EXCEL
Posts: | Location: 115 Chicago, IL | Registered: May 28, 2004
posted September 24, 2007 03:16 PM
In WebFOCUS the function is called LCWORD.
LCWORD(length, string, outfield)
SYSTEMDESC/A40 = LCWORD(40, SYSTEM_DESC, 'A40');
Take a look at "Character Functions" in the Function Reference document.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
Posts: | Location: 10577 Toronto, Ontario, Canada | Registered: April 27, 2005
posted September 24, 2007 04:01 PM
Thank you All .It's working i,e LCWORD...
posted September 25, 2007 08:42 AM
msam: sorry, I suppose since your original post even referenced the oracle (?) function InitCap, you probably already know that you can do this in the SQL world.
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database. Read-Only Topic
Copyright © 1996-2020 Information Builders