A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Description | Example | Result | |||
2 | <?xdofx: EXPRESSION?> | <?xdofx:2+3-4*5/6?> | 1.666...667 | |||
3 | <?xdofx: STRING||STRING?> | Concatenate string | <?xdofx: FNAME||LNAME?> | 'JohnSmith' | ||
4 | <?xdofx:ceil(NUMBER)?> | Rounds the number up | <?xdofx:ceil(123.45)?> | 124 | ||
5 | <?xdofx:chr(ASCII)?> | Return character from ASCII code | <?xdofx:chr(097)?> | a | ||
6 | <?xdofx:decode(EXPRESSION, SEARCH, RESULT [, SEARCH, RESULT]...[, DEFAULT])?> | Similar to If-Else statement | <?xdofx:decode('abc','xxx','Result01','abc,'Result02','Default')?> | 'Result02' | ||
7 | <?xdofx:floor(NUMBER)?> | Similar to If-Else statement | <?xdofx:floor(456.78)?> | 456 | ||
8 | <?xdofx:greatest(EXPRESSION [, EXPRESSION ... ] )?> | Returns largest expression | 6 (2*3) | |||
9 | <?xdofx:if EXPRESSION then TRUE else FALSE end if?> | Conditional statement | <?xdofx:greatest(1+1 , 2*3, 4-5, 6/7)?> | - | ||
10 | <?xdofx:least(EXPRESSION [, EXPRESSION ... ] )?> | Search for character in string | <?xdofx:Instr('abcabcabca', 'a', 2, 2)?> | 7 | ||
11 | Returns smallest expression | <?xdofx:least(1+1 , 2*3, 5-4)?> | 1 (5-4) | |||
12 | <?xdofx:length(STRING)?> | Returns numeric length of string | <?xdofx:length('This is a test')?> | 14 | ||
13 | <?xdofx:lower(STRING)?> | Convert string to lowercase | <?xdofx:lower('TEST')?> | 'test' | ||
14 | <?xdofx:lpad(STRING, NUM_CHARS, PAD_CHAR)?> | Left pad | <?xdofx:lpad(LAST_NAME, 10, '.')?> | '..........Smith' | ||
15 | <?xdofx:replace(STRING, FIND_STR, REP_STR)?> | Replace string within string | <?xdofx:replace(name, 'John', 'Jon')?> | name = 'Jon Smith' | ||
16 | <?xdofx:round(NUMBER [, DECIMALS])?> | Round number | <?xdofx:round(1.23 , 1)?> | 1.20 | ||
17 | 0 | Right pad | <?xdofx:rpad(FIRST_NAME, 3, 'X')?> | 'JohnXXX' | ||
18 | <?xdofx:substr(STRING, START_POS, LENGTH)?> | Extract portion of string | <?xdofx:substr('abcdefg', 2, 3)?> | 'bcd' | ||
19 | <?xdofx:sysdate()?> | Retrieve system date | - | 4/18/23 | ||
20 | <?xdofx:to_char(NUMBER)?> | Convert number to string | <?xdofx:to_char(12345)?> | '12345' | ||
21 | Format date | <?xdofx:to_date(20111231, 'DAY - DD/MM/YYYY_HH:MI:SS')?> | 31/12/2011 OR 12.31.11 | |||
22 | <?xdofx:to_number(ACGFinalisedReconCasesCountCalc)?> | Convert string to number | <?xdofx:to_number('12345')?> | 12345 | ||
23 | <?xdofx:upper(STRING)?> | Convert string to uppercase | <?xdofx:upper('test')?> | 'TEST' | ||
24 | ||||||
25 | <?xdofx:to_date(CASHSETTLEDDATE, 'DAY - DD/MM/YYYY_HH:MI:SS')?> | |||||
26 | CASHSETTLEDDATE | |||||
27 | ||||||
28 | ||||||
29 | ||||||
30 | ||||||
31 | ||||||
32 | ||||||
33 | ||||||
34 | ||||||
35 | ||||||
36 | ||||||
37 | ||||||
38 | ||||||
39 | ||||||
40 | ||||||
41 | ||||||
42 | ||||||
43 | ||||||
44 | ||||||
45 | ||||||
46 | ||||||
47 | ||||||
48 | ||||||
49 | ||||||
50 | ||||||
51 | ||||||
52 | ||||||
53 | ||||||
54 | ||||||
55 | ||||||
56 | ||||||
57 | ||||||
58 | ||||||
59 | ||||||
60 | ||||||
61 | ||||||
62 | ||||||
63 | ||||||
64 | ||||||
65 | ||||||
66 | ||||||
67 | ||||||
68 | ||||||
69 | ||||||
70 | ||||||
71 | ||||||
72 | ||||||
73 | ||||||
74 | ||||||
75 | ||||||
76 | ||||||
77 | ||||||
78 | ||||||
79 | ||||||
80 | ||||||
81 | ||||||
82 | ||||||
83 | ||||||
84 | ||||||
85 | ||||||
86 | ||||||
87 | ||||||
88 | ||||||
89 | ||||||
90 | ||||||
91 | ||||||
92 | ||||||
93 | ||||||
94 | ||||||
95 | ||||||
96 | ||||||
97 | ||||||
98 | ||||||
99 | ||||||
100 |