www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY
and
append
assign
avg
boolean
ceiling
concat
contains
count
create-attribute
create-comment
create-element
create-pi
current
distinct
doc
document
document-literal
empty
ends-with
every
except
false
filter
floor
fn:collection
for
format-number
function-available
generate-id
id
if
intersect
is_after()
is_before()
key
lang
last
let
list()
local-name
max
min
name
namespace-uri
normalize-space
not
number
or
position
processxquery
processxslt
processxsql
progn()
replace()
round
serialize
shallow
some
starts-with
string
string-length
substring
substring-after
substring-before
sum
system-property
text_contains()
translate
true
tuple()
union
unordered
unparsed-entity-uri
urlify
xmlview

Functions Index

substring-after

Returns the substring of the first argument string that follows the first occurrence of the second argument string in the first argument string.
string substring-after ( source_strg string, sub_strg string);
Description

If the source_strg does not contain sub_strg, the function returns the empty string. Otherwise, it finds the first occurrence of sub_strg and returns the pert of source_strg that follows the occurrence. If any argument is not a string, it is converted to string using rules for string() XPATH function.

Parameters
source_strg – String where the search is performed
sub_strg – String to search
Return Types

String

Examples

Extract time and timezone ("23:59:59 GMT" substring) from timestamp

substring-after('1999-12-31 23:59:59 GMT',' ')