Focal Point
[SOLVED] Set values to lower case

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6587010376

October 09, 2014, 11:18 AM
Scott Matson
[SOLVED] Set values to lower case
How do I make the values of a variable lower case? When I run this:

-SET &USR = CNCTUSR('a12');

-TYPE &USR

my username comes in lowercase. When my coworkers runs it, their name comes in upper case. I want all values returned to be lower case. How do I do this?

This message has been edited. Last edited by: Scott Matson,


WebFOCUS 8007
October 09, 2014, 11:44 AM
Shakila Subhan
Hi,
use LOCASE function.
-SET &IBIC_user = 'SCOTT MATSON';
-SET &IBIC_user = LOCASE(&IBIC_user.LENGTH, &IBIC_user, 'A&IBIC_user.LENGTH');
-TYPE &IBIC_user
-EXIT


WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
October 09, 2014, 11:59 AM
Scott Matson
That did exactly what I needed! Thanks!


WebFOCUS 8007
October 09, 2014, 04:40 PM
Waz
It pays to do a search of the documentation.

If this has solved your issue, please update your first post in this thread and add [SOLVED] or [CLOSED] to the title


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!