BI Publisher Function Listing v1
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
FunctionDescriptionExampleResult
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])?><?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 expression6 (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
<?xdofx:rpad(STRING, NUM_CHARS, PAD_CHAR)?>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-12/7/16
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(STRING)?>Convert string to number<?xdofx:to_number('12345')?>12345
23
<?xdofx:upper(STRING)?>Convert string to uppercase<?xdofx:upper('test')?>'TEST'
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Loading...
 
 
 
XDOFX
MAIN
XPATH Notations
DATE_MASK
XDOXSLT
FO
XSL
Dynamic Image
COLOR names