XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is

for extended SQL functions <?xdofx:expression?>

for extended XSL functions<?xdoxslt:expression?>

Example of Extended SQL Functions

<?xdofx:decode(’xxx’,’bbb’,’ccc’,’xxx’,’ddd’)?>
<?xdofx:Instr(’abcabcabc’,’a’,2)?>
<?xdofx:substr(’abcdefg’,2,3)?>
<?xdofx:to_number(’12345’)?>
<?xdofx:replace(name,’John’,’Jon’)?>

Recent Posts

Start typing and press Enter to search