Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Lower Case and Upper Case issues

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Lower Case and Upper Case issues
 Login/Join
 
N/A
Gold member
posted
If I pass lower case, the report doesn’t work. Is there anycode where it will ignore if I put lowercase instead of Uppercase.
Here is my code:
-DEFAULT &p_Covertype = ' a';
VARTYPE CHECK = A = AssistedLivingCare
B = BusinessProperty
C = GreenwiseUpgrade
so on...
-IF &p_Covertype NE 'A' THEN GOTO SKIP_A;
Alc
Atc
-GOTO Done;
-SKIP_A;
-IF &p_Covertype NE 'B' THEN GOTO SKIP_B;
Bpa
Bpaa
Bpt
-SKIP_B;
Done;

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows 7
HTML
 
Posts: 50 | Registered: August 18, 2015Report This Post
Tim P.
Platinum Member
posted Hide Post
Off the top of my head I don't think there is. You could do use the UPPERCASE function on &p_Covertype so no matter the input, it is always uppercase.

-SET &p_Covertype = UPCASE(&p_Covertype.LENGTH,&p_Covertype,&p_Covertype);


WebFOCUS App Studio 8.2.02
Windows 7, All Outputs
 
Posts: 141 | Location: Mclean, VA | Registered: December 04, 2012Report This Post
RSquared
Guru
posted Hide Post
You can also just code it as

IF UPCASE (&p_covertype) NE 'A' etc


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Ricardo Augusto
Guru
posted Hide Post
N/A you are a GOTO lover!


WebFOCUS 8.1.05 / APP Studio
 
Posts: 272 | Location: Brazil | Registered: October 31, 2006Report This Post
N/A
Gold member
posted Hide Post
quote:
Originally posted by Ricardo Augusto:
N/A you are a GOTO lover!

Thanks. I want even if I put A or a it should work. The code is working fine if I put UPPER CASE A,B,C etc. But instead of uppercase if I put a or b it does not work. My question: if there are any code which can ignore a or A. Even if I put a it should work.


WebFOCUS 8
Windows 7
HTML
 
Posts: 50 | Registered: August 18, 2015Report This Post
Squatch
Master
posted Hide Post
quote:
Originally posted by Ricardo Augusto:
N/A you are a GOTO lover!

GOTO this!


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
dhagen
Virtuoso
posted Hide Post
quote:
My question: if there are any code which can ignore a or A. Even if I put a it should work.


Nope.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Waz
Expert
posted Hide Post
If you are on the right version of 8, you can use the simplified function UPPER.

Simplified Character Functions


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
N/A
Gold member
posted Hide Post
IF UPCASE(&p_Covertype) NE 'A' THEN GOTO SKIP_ALC;
ALCC
ACTP
-GOTO DWCTC;
-SKIP_ALC;
-IF UPCASE(&p_Covertype) NE 'B' THEN GOTO SKIP_BP;
BPC
BPCA
-SKIP_BP;
-Done;


error;
FOCUS FUNCTION HAS INCORRECT NUMBER OF ARGUMENTS: UPCASE


please suggest


WebFOCUS 8
Windows 7
HTML
 
Posts: 50 | Registered: August 18, 2015Report This Post
Squatch
Master
posted Hide Post
UPCASE(1,&p_Covertype,'A1')


App Studio
WebFOCUS 8.1.05M
Windows, All Outputs
 
Posts: 594 | Location: Michigan | Registered: September 04, 2015Report This Post
Waz
Expert
posted Hide Post
N/A, It would be a very good idea to check the documentation on functions.

Its all explained there

Character Functions

Simplified Character Functions


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
BabakNYC
Virtuoso
posted Hide Post
To expand on Squatch's example, in case the string has a variable length:

UPCASE(&p_Covertype.LENGTH, &|p_Covertype, 'A&p_Covertype.LENGTH');


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
N/A
Gold member
posted Hide Post
Thnaks.
code:
-DEFAULT &p_Covertype ='C'; or c anything

VARTYPE CHECK =
A = AssistedLivingCare
B = BusinessProperty
C = GreenwiseUpgrade
D = HomeUnitAsseseement
E = HomeAssociationPolDedAssessment
so on.......
IF UPCASE(1,&p_Covertype,'A1') NE 'A' THEN GOTO SKIP_ALC;
........
-IF UPCASE(1,&p_Covertype,'B1') NE 'B' THEN GOTO SKIP_BP;
..........
-IF UPCASE(1,&p_Covertype,'C1') NE 'C' THEN GOTO SKIP_GWU;
..........
-IF UPCASE(1,&p_Covertype,'D1') NE 'D' THEN GOTO SKIP_HUA;
...........
-IF UPCASE(1,&p_Covertype,'E1') NE 'E' THEN GOTO SKIP_HPDA;
........

note: A or a, B or b, C or c working well......from D on wards not working


WebFOCUS 8
Windows 7
HTML
 
Posts: 50 | Registered: August 18, 2015Report This Post
BabakNYC
Virtuoso
posted Hide Post
Syntax: How to Convert Text to Uppercase

UPCASE(length, source_string, output)

where:

length

    Integer

    Is the number of characters in source_string and output.
input

    Alphanumeric

    Is the string to convert.
output

    Alphanumeric of type AnV or An

    If the format of the output_format is AnV, then the length returned is equal to the smaller of the source_string length and the upper_limit length.


The last parameter is the format of the output in single quotes. In your case it'll always be A1.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
N/A
Gold member
posted Hide Post
Thanks a lot! Finally got the answers and it is working now.... Good One


WebFOCUS 8
Windows 7
HTML
 
Posts: 50 | Registered: August 18, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Lower Case and Upper Case issues

Copyright © 1996-2020 Information Builders