Question Re: multiple operators AND / OR in Technology Q&A

multiple operators AND / OR

Former Member — Wed, 27 Sep 2017 16:15:15 GMT

Hello,

Could somebody explain me how to use multiple operators AND vs OR in this case:

Global StringVar Type ;
If UBound(myString)>=1
Then Type:= ToText(myString[1]);
Type := If Type = "F1A" Or Type = "F1E" Or Type = "F6A" Or Type = "F6E" Then "F";
Type := If Type = "G1A" Or Type = "G1E" Or Type = "G6A" Or Type = "G6E" Then "G";

Global StringVar Design ;
If UBound(myString)>=2
Then Design:= ToText(myString[2]);
Design := Replace (Design,"I","");
Design := If (Design = "20") and (Type = "F") Or (Design = "21") and (Type = "F") Or (Design = "22") and (Type = "F") Then "2" ;
Design

Re: multiple operators AND / OR

abhilash_kumar — Wed, 27 Sep 2017 17:29:31 GMT

Hi Zdenek,

Please try:

Global StringVar Type ;
If UBound(myString)>=1
Then Type:= ToText(myString[1]);
Type := If Type IN ["F1A","F1E","F6A","F6E"] Then "F" Else If Type IN ["G1A","G1E","G6A","G6E"] Then "G";
Global StringVar Design ;
If UBound(myString)>=2
Then Design:= ToText(myString[2]);
Design := Replace (Design,"I","");
Design := If (Design = "20" and Type = "F") Or (Design = "21" and Type = "F") Or (Design = "22" and Type = "F") Then "2" ;
Design

-Abhilash

Re: multiple operators AND / OR

Former Member — Mon, 02 Oct 2017 10:37:16 GMT

super.....works nice

I already found and used if + multiple times else if instead of the OR , but Your style seems to be shorter record, so I will use it.

Thank You