topic locating a string in a string in an SP in Developers

locating a string in a string in an SP

robm — Mon, 26 Oct 2015 14:59:21 GMT

I tried this

%macro getserver;

%LET x=index(&_srvname, "uview");

%IF x > 0 %THEN %LET server=https://&_srvname&_url; %ELSE %LET server=http://&_srvname:&_srvport&_url;

%mend;

x seems to evaluate to "index(sas2.domain.com,"uview");" how would I get it to evaluate to a numeric value

BrunoMueller — Mon, 26 Oct 2015 15:16:22 GMT

Since you are using the macro language you also have to use macro functions like %INDEX

Please note, that in the macro language you do not need the quotes around text. So your example would look like:

%LET x = %index(&_srvname, uview);

Bruno

Astounding — Mon, 26 Oct 2015 15:42:12 GMT

Building upon what Bruno has mentioned ...

Once you follow his advice, you would need to change the way you refer to the macro variable X by adding an ampersand:

%if &X > 0 %then ...

Alternatively, just get rid of X entirely:

%if %index(&_srvname, uview) > 0 %then ...