Macro Scheduler 15

Examples

Numeric Functions:

 

Let>rounded={round(34.6)}

Let>ans={cos(340)}

 

Using numeric variables in complex expressions we enclose variables in % symbols:

 

Let>decimal=34.6

Let>rounded={round(%decimal%)}

 

String Functions:

 

In Complex expressions string literals must be enclosed in double quotes (").  Variables are just enclosed with % symbols:

 

Let>[email protected]

Let>at={Pos("@",%email%)}

 

Here at equals 5 as it is the 5th character in [email protected]

 

Let's now use the copy function to extract everything before the @ sign:

 

Let>namepart={copy(%email%,1,%at%-1)}

 

Conditional Functions:

 

Let>[email protected]

Let>IsItAnEmail={if(pos("@",%email%)>0,"yes","no")}

 

Of course we could do:

 

Let>[email protected]

Let>at={Pos("@",%email%)}

Let>IsItAnEmail={if(%at%>0,"yes","no")}

 

Here IsItAnEmail would be set to "yes".