summaryrefslogtreecommitdiffstats
path: root/test/04-function-right.txt
blob: e12cf714eaae6e6183b42126c8e95a2c6f764760 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
%% Test built-in function RIGHT.
%mode init
A1@ABCDE
A2:12345
B1=RIGHT(A1)
B2=RIGHT(A1,0)
B3=RIGHT(A1,1)
B4=RIGHT(A1,2)
B5=RIGHT(A1,3)
B6=RIGHT(A1,4)
B7=RIGHT(A1,5)
B8=RIGHT(A1,6)
B9=RIGHT(B8,3)
C1=RIGHT(A2)
C2=RIGHT(A2,0)
C3=RIGHT(A2,1)
C4=RIGHT(A2,2)
C5=RIGHT(A2,3)
C6=RIGHT(A2,4)
C7=RIGHT(A2,5)
C8=RIGHT(A2,6)
C9=RIGHT(C8,2)
D1=RIGHT(A1,-1)
%calc
%mode result
B1="E"
B2=""
B3="E"
B4="DE"
B5="CDE"
B6="BCDE"
B7="ABCDE"
B8="ABCDE"
B9="CDE"
C1="5"
C2=""
C3="5"
C4="45"
C5="345"
C6="2345"
C7="12345"
C8="12345"
C9="45"
D1=#VALUE!
%check